SELECT
TOP 1
tna.*, tpn.*, tona.*, tt.*, mm.*, pp.*
FROM
Pub.Trans AS tt
INNER JOIN Pub.Mortgage AS mm ON tt.CNTY_CD = mm.CNTY_CD
AND tt.BATCH_DT = mm.BATCH_DT
AND tt.BATCH_SEQ = mm.BATCH_SEQ
AND tt.MUNC_CD = mm.MUNC_CD
INNER JOIN Pub.PROPERTY AS pp ON tt.CNTY_CD = pp.CNTY_CD
AND tt.PCL_ID = pp.PCL_ID
AND tt.PCL_SEQ_NBR = pp.PCL_SEQ_NBR
AND tt.MUNC_CD = pp.MUNC_CD
AND mm.CNTY_CD = pp.CNTY_CD
AND mm.PCL_ID = pp.PCL_ID
AND mm.PCL_SEQ_NBR = pp.PCL_SEQ_NBR
AND mm.MUNC_CD = pp.MUNC_CD
LEFT OUTER JOIN Pub.TransNameAddress AS tna ON tt.CNTY_CD = tna.CNTY_CD
AND tt.BATCH_DT = tna.BATCH_DT
AND tt.BATCH_SEQ = tna.BATCH_SEQ
AND tt.MUNC_CD = tna.MUNC_CD
AND tna.NAME_TYPE = 'NAME_TYPE'
LEFT OUTER JOIN Pub.TransOriginalNameAddress AS tona ON tt.CNTY_CD = tona.CNTY_CD
AND tt.BATCH_DT = tona.BATCH_DT
AND tt.BATCH_SEQ = tona.BATCH_SEQ
AND tt.MUNC_CD = tona.MUNC_CD
AND tona.NAME_TYPE = 'NAME_TYPE'
AND tona.NAME_SEQ = 1
AND tna.CNTY_CD = tona.CNTY_CD
AND tna.BATCH_DT = tona.BATCH_DT
AND tna.BATCH_SEQ = tona.BATCH_SEQ
AND tna.MUNC_CD = tona.MUNC_CD
AND tna.NAME_TYPE = tona.NAME_TYPE
LEFT OUTER JOIN Pub.TransParsedName AS tpn ON tt.CNTY_CD = tpn.CNTY_CD
AND tt.BATCH_DT = tpn.BATCH_DT
AND tt.BATCH_SEQ = tpn.BATCH_SEQ
AND tt.MUNC_CD = tpn.MUNC_CD
AND tpn.NAME_TYPE = 'NAME_TYPE'
AND tpn.NAME_SEQ = 1
AND tna.CNTY_CD = tpn.CNTY_CD
AND tna.BATCH_DT = tpn.BATCH_DT
AND tna.BATCH_SEQ = tpn.BATCH_SEQ
AND tna.MUNC_CD = tpn.MUNC_CD
AND tna.NAME_TYPE = tpn.NAME_TYPE
LEFT OUTER JOIN Pub.TransOriginalNameAddress AS byr ON tt.CNTY_CD = byr.CNTY_CD AND tt.BATCH_DT = byr.BATCH_DT AND tt.BATCH_SEQ = byr.BATCH_SEQ AND tt.MUNC_CD = byr.MUNC_CD AND byr.NAME_TYPE = 'BUYR' AND byr.NAME_SEQ = 1
LEFT OUTER JOIN Pub.TransOriginalNameAddress AS slr ON tt.CNTY_CD = slr.CNTY_CD AND tt.BATCH_DT = slr.BATCH_DT AND tt.BATCH_SEQ = slr.BATCH_SEQ AND tt.MUNC_CD = slr.MUNC_CD AND slr.NAME_TYPE = 'SELLER' AND slr.NAME_SEQ = 1
WHERE 1 = 0