insert_recordset tmp_Table (TransTableID,TransRecID) select TransTableID from MarkUpTrans join RecId from VendInvoiceTrans WHERE VendInvoiceTrans.InvoiceId == "XXX" && MarkUpTrans.TransRecId == VendInvoiceTrans.RecId;