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

Hi All, Can anyone help me how we can use outer join in suiteql . I tried outer Join but it doesnt work.

<@U02053YFW1H> SELECT
TransactionLine.Transaction as tid
FROM
TransactionLine
OUTER JOIN Item ON (TransactionLine.item=item.id) where item.id=134543

You probably need to specify LEFT/RIGHT OUTER JOIN