Hi, I'm trying to pull support case data and join a contact record, however, I'm struggling to find a relation between tables. Does NetSuite have a joint table between them? Also, the XML record representation contains contact and contactid but both of them return an error while pulled.

SELECT
--SC.contact
SC.contactid

FROM
supportCase AS SC


WHERE
--SC.company = xxx
--AND
SC.id = xxx

Record Catalog suggests to me yes, maybe ask in the suiteql channel:

Thanks, Have the same structure on my end. I will publish this on suiteql channel.