FAQ: What's the Difference Between Address and Addresses Tables?

Use the Address table in the Advanced Query Wizard output fields when you want to see a constituent's seasonal address in your query results appropriate for the current date. If you wish to return only the seasonal address that is appropriate for the current date, select Address.

Use the Addresses table to return all addresses for constituents, regardless of seasonal address settings, yet dependent on any query filters you set. Your query results are not restricted to just seasonal addresses when you use the Addresses table.  

Address and Addresses are mutually exclusive - Salsa CRM will not allow you to select entries from both tables. You should only select fields from either the Address or the Addresses tables within the same query.