SuiteQL Customer Address Tables Explained
Understand Customer, CustomerAddressBook and CustomerAddressBookEntityAddress and join them correctly in SuiteQL.
Addresses
3 notes in this thread.
Why SuiteQL Customer Address Joins Return Duplicate Rows
Diagnose duplicate customer rows in SuiteQL address queries and choose the correct result grain instead of relying on DISTINCT.
SuiteQL: Get the Default Billing and Shipping Address
Return a customer default billing address, default shipping address or both with SuiteQL while retaining customers without an address.