This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hey All - I am attempting to grab a Partner ID from an EntityAddressBookAddress, but cannot for the life of me figure out how/where to join to make this happen.  Any assistance is appreciated!

SELECT
    *
FROM
    PartnerAddressbook
    INNER JOIN PartnerAddressbookEntityAddress ON PartnerAddressbook.addressbookaddress = PartnerAddressbookEntityAddress.nkey
WHERE
    PartnerAddressbook.entity IN (&lt;&lt;INSERT PARTNER ID&gt;&gt;)

Thanks <@U029A7U3VMM>!  I'll give this a shot.