I want to select all addressees of a customer, alo...
# suiteqls
Simon
05/03/2022, 8:42 PMI want to select all addressees of a customer, along with default billing. I'm not sure of which table. Anyone have an idea ?
j
jen
05/03/2022, 11:24 PM Copy code
SELECT entityaddress.* FROM entityaddress
JOIN entityaddressbook ON (entityaddressbook.addressbookaddress = entityaddress.nkey)
WHERE entityaddressbook.entity = <id of your customer>5 Views