select faa.Asset_SN_ID ,faa.PCV_ID,faa.Asset_Code,faa.Serial_No,(famain.Asset_Code+famain.Serial_No) as PCVDescription
from
tblfixedasset as famain inner join tblfixedasset as faa on famain.Asset_SN_ID = faa.PCV_ID
where faa.Asset_Code='GSR-U' and faa.Serial_No='1224'