This issue has been resolved. Thanks

Thanks for responding.

I made this change to the main query

Select Prod_Code, [Code 1], [Code 2], [Code 3] from

(

Select a.Prod_Code, a.Descr, b.Prod_Code'MSProdCode', b.Ship_Code'MSShipCode'

from #AllRecords a

left outer...