Hi,
I have this query
SELECT
c2.id_number AS Cusip, c1.id_number AS Isin, c3.id_number AS Sedol,
c4.id_number AS Cusip144a, c5.id_number AS Isin144a,
ISNULL(fii.party_short_name, fii.party_long_name) AS DESCRIPTION,
bintostr(a.asset_id) AS ASSET_ID
FROM govcorp..asset a LEFT JOIN...