I need join water district 1 all parcel with this active water account apn table by APN 



direct join with APN will not work, nothing join, see below you get empty null  value on joined apn field. 


 the reason is because active water account table's apn length is 30, text, it has lots of space after 9 digital number.






 after remove all space in APN field,  use APN_staging to join then success





select all parcel,  which APN is null, means which do not have a active water bill account. 


 export layer







Please log in or register