SELECT * FROM ASS_ADDNEW WHERE ADDNEW_ID IN ('ASA000000254220','ASA000000254235') SELECT * FROM ASS_ENTRIES_POST WHERE TRN_ID IN ('ASA000000254235','ASA000000254220') SELECT * FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235') SELECT * FROM ASS_MASTER WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235')) SELECT * FROM ASS_AMORT_DT WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_MASTER WHERE ASSET_ID IN (SELECT ASSET_ID FROM ASS_TRANSACTIONS WHERE TRN_ID IN ('ASA000000254220','ASA000000254235')))