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

Can someone help me access the related records of a case via SuiteQL? I'm not sure what table they are located. Thx

SELECT
	supportcase.casenumber,
	transaction.id

FROM
	supportcase
	INNER JOIN transaction ON
		(transaction.id = supportCase.id)
WHERE
	supportcase.casenumber = 213778