SuiteQL: Join Tables-Transactions and Items

SELECT transaction.tranid AS sales_order, 
       item.itemid AS item_name, 
       transactionlines.quantity AS quantity_sold 
FROM transaction 
INNER JOIN transactionlines 
ON transaction.id = transactionlines.transaction 
INNER JOIN item 
ON transactionlines.item = item.id 
WHERE transaction.type = 'SalesOrd' 
AND transaction.trandate BETWEEN {today}-90 AND {today};

Combines data from transaction, transactionlines, and item tables using INNER JOIN.

Fetches sales order numbers (tranid), item names (itemid), and quantities sold (quantity).

Filters transactions of type SalesOrd from the last 90 days.