use t22s001 delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL where SRNO NOT IN (select RECSRNO from send_to_job_item_detail) delete from OPENING_CHALLAN_RECEIVED_FROM_JOB where SRNO NOT IN (select RECSRNO from send_to_job_item_detail)
use t22s001 delete from OPENING_CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL where SRNO NOT IN (select RECSRNO from send_to_job_item_detail) delete from OPENING_CHALLAN_RECEIVED_FROM_JOB where SRNO NOT IN (select RECSRNO from send_to_job_item_detail)