Hi All, We are using the ODBC connection to create some reports and we are selecting the data from the invoice record using this select statement. The issue is that for the assembly items in the invoice, we are getting all the Assembly components. Does anyone know how to get only the assembly? SELECT TRANSACTION_LINES.* FROM TRANSACTIONS INNER JOIN TRANSACTION_LINES ON TRANSACTIONS.TRANSACTION_ID = TRANSACTION_LINES.TRANSACTION_ID LEFT JOIN ITEMS ON (ITEMS.ITEM_ID = TRANSACTION_LINES.ITEM_ID) WHERE TRANSACTIONS.TRANSACTION_TYPE = 'Invoice'