SELECT FROM doctor_orders doWHERE NOT EXISTS SELECT 1 FROM clinical_vs_patient cvp WHERE cvppatient_id = dopatient_idAND NOT EXISTS SELECT 1 FROM CLINICAL_TRIAL_MASTER ctm WHERE ctmid = doCLINICAL_TRI

UPDATE doctor_orders SET CLINICAL_TRIAL_NO = NULL WHERE NOT EXISTS (SELECT 1 FROM clinical_vs_patient cvp WHERE cvp.patient_id = doctor_orders.patient_id) AND NOT EXISTS (SELECT 1 FROM CLINICAL_TRIAL_MASTER ctm WHERE ctm.id = doctor_orders.CLINICAL_TRIAL_NO)