using SuiteQL, access all Vendor address by address id

AI generated answer (using internal Slack threads):

To access all Vendor address by address id using SuiteQL, you can use the

vendoraddressbook

and

address

tables. The

vendoraddressbook

table contains the relationship between the vendor and the address, and the

address

table contains the actual address details. Here is a sample SuiteQL query:

sql
SELECT v.entityid, a.addr1, a.addr2, a.city, a.state, a.zip 
FROM vendor v
JOIN vendoraddressbook va ON v.id = va.vendor 
JOIN address a ON va.address = a.id
WHERE a.id = {address_id}

Replace

{address_id}

with the actual address id you want to filter by. Please note that this query assumes that the address id is unique across all vendors. If the same address id can be used by multiple vendors, you might get multiple rows in the result. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******