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
