use T23H001 select * from challan_received_from_job_challan_detail where jobsendsrno not in (select srno from send_to_job union select srno from opening_send_to_job)
use T23H001 select * from challan_received_from_job_challan_detail where jobsendsrno not in (select srno from send_to_job union select srno from opening_send_to_job)