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

Is this not valid? SELECT * FROM transaction INNERJOIN transactionLine ON transaction.id = transactionLine.id WHERE type = 'SalesOrd' ?

The ON part needs to link the transaction id, not the transactionline id. 

ie ON <http://transaction.id|transaction.id> = transactionline.transactionid

SELECT * FROM transaction INNERJOIN transactionLine ON transaction.id = transactionLine.transaction

Still throwing error. <@UH8L0UJAU> <@U01L5NFD9SA>

It worked! Thanks <@UH8L0UJAU> <@U03KHSM456G> <@U01L5NFD9SA>
But I don't see any lines data.

```SELECT
  transaction.id,
  transactionLine.id as lineId,
FROM
  transaction
  INNER JOIN transactionLine ON transaction.id = transactionLine.transaction
WHERE
  type = 'SalesOrd'```
that worked for me. are you sure there are sales orders?

Hi <@U029A7U3VMM> yes there are sales order. Lines data is showing up as a separate result. I was trying to find it within the transaction result.

could you clarify by “I was trying to find it within the transaction result”?

I was assuming there will be "items" array within the sales order object. but it appears as a separate object in the result array.

yes, each line will be it’s own row. You can then group them in JS. It makes it much easier to be able to query transaction lines directly