use T24S001 select * from item_finalization where toplotno='1655' select * from TblIFChallanTblIFChallan_KING where LotNo='1655' select * from FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL where LotNo='1655' select * from grey_send_to_mill where SrNo ='000024' select * from GREY_SEND_TO_MILL_TAKA_DETAIL where SrNo ='000024' select * from opening_grey_send_to_mill where SrNo='00094' select * from GREY_RETURN_FROM_MILL_CHALLAN_DETAIL where millsendSrNo='00094' update FINISHED_RECEIVED_FROM_MILL_CHALLAN_DETAIL set finitemname = ''