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

i m still not sure how to join the transaction line for the bill on the PO this is what I have so far
```SELECT
transaction.ID as transaction_id,  
transactionLine.ID as transactionLine_id, 
transactionLine.item as item_id,
transactionLine.custcol6 as po_number,
FROM transaction
JOIN  transactionLine ON transaction.ID = transactionLine.transaction
 WHERE transaction.ID = 13636399 AND transactionLine.item  IS NOT NULL```

FYI best place to ask SuiteQL questions is <#C01FBBZ8PQC|>