In Connect ODBC, does anyone know how to join to the transaction_lines row of that lines discount from the transaction_lines row of the item with the discount? In my transaction_lines data, the transaction_line_id of the discount is immediately after the the transaction_line_id of the item (IE 2 and 3), but sometimes the transaction_line_id of the item is 7 and the transaction_line_id of the discount is 12 (So they're not in consecutive order).