DECLARE @tmp VARCHAR(25),@ASSET_ID VARCHAR(25)
SELECT @ASSET_ID=ASSET_ID FROM dbo.ASS_MASTER WHERE ASSET_CODE='069TS24010012220001'
SELECT @tmp=TRN_ID FROM ASS_TRANSACTIONS WHERE ASSET_ID =@ASSET_ID
SELECT * FROM dbo.ASS_ADDNEW WHERE ADDNEW_ID =@tmp
SELECT * FROM dbo.ASS_MASTER WHERE ASSET_CODE =@ASSET_ID
SELECT * FROM dbo.ASS_ENTRIES_POST WHERE ASSET_ID =@ASSET_ID