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

select
              transaction.transactionnumber.
              transaction.trandisplayname,
              bomAssembly.assembly,
              bomAssembly.billOfMaterials,
              bomAssembly.canBeMaster,
              bomAssembly.masterDefault
FROM
              transaction
join bomAssembly on transaction.billofmaterials = bomAssembly.billofmaterials
where type = 'WorkOrd'

not sure your question, but there is a syntax error. The first column (`transactionnumber`) has a period after the name instead of a comma