@Simon Definitely seems odd. Try this and see what happens:

SELECT

TransactionLine.Transaction AS TransactionID,

( SELECT LastModifiedDate FROM Transaction WHERE ID = TransactionLine.Transaction ) AS LastModifiedDate

FROM

TransactionLine

WHERE

TransactionLine.custcol_list_id = 1410290178