You are right. I pasted the SQL, here is the SuiteQL SELECT TransactionLine.Transaction AS TransactionID FROM TransactionLine INNER JOIN Transaction ON ( Transaction.ID = TransactionLine.Transaction ) WHERE TransactionLine.custcol_list_id = 1410290178