SELECT * FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008') SELECT * FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008')) AND BRANCH_ID ='BRN000000000416' SELECT * FROM MW_OUT_DT WHERE MAST_BAL_ID IN (SELECT MAST_BAL_ID FROM MW_MAST_BAL WHERE PRICE_ID IN (SELECT PRICE_ID FROM MW_MAST_PRICE WHERE PRICE_CODE IN ('069CSKH200084006', '069CSKH200084007', '069CSKH200084008')) AND BRANCH_ID ='BRN000000000416')