9. Click Address Lines
B. Now we will create a compound query to subtract out all of the accounts with an address (the query created above) from all constituent accounts in your database:
The compound query created in Step B will contain all accounts without an address.
This required two queries because if we try to create one query using the Address Lines field, and check off 'Field has no value', we may return some accounts that have multiple Personas with one missing an address. For example, if a constituent has both a Business and Personal persona, but only the Personal persona has an address, that constituent would be returned if we create one query with 'Field has no value' checked off within the Address Lines field, because they do have a Persona that does not have an address present. For that reason, it is best to create a compound to subtract out accounts that have an address on any of their personas, so that your results accurately produce accounts that do not have an address in any persona.