USE T22M001

select * from GREY_SEND_TO_MILL_TAKA_DETAIL where srno in (
SELECT Distinct SrNo FROM GREY_SEND_TO_MILL_TAKA_DETAIL WHERE rfSRNO IN (
SELECT frsrno FROM FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL WHERE LOTNO='16216')
)



--UPDATE GREY_SEND_TO_MILL_TAKA_DETAIL SET RFSRNO='000034', RFISRNO=2 WHERE SRNO='000496'