...
SELECT
a.[request_time],
a.[response_time],
ba.[masked_pan],
a.[stan],
a.[message_name],
a.[response_code],
cast(a.cast([request_amount] as money)/100 as request_amount,
a.[retrieval_reference_number],
a.[card_acceptor_id],
a.[terminal_id],
a.[card_acceptor_location],
a.[mti],
a.[transaction_search_key]
...
INNER JOIN
[aptent_db].[dbo].[bank_transfer_transaction] b
ON
a.[transaction_search_keyid] = b.[transaction_searchrecord_keyid]
WHERE
concat(a.[terminal_id],a.[retrieval_reference_number]) IN ('2TFD0UU6000172503150')