SELECT * FROM shchyy.tb_patient p WHERE p.hosp_number NOT in(SELECT number FROM shchyy.tb_hosp) SELECT * FROM shchyy_geca.tb_patient p WHERE p.hosp_number NOT in(SELECT number FROM shchyy_geca.tb_hosp) SELECT * FROM shchyy_qg.tb_patient p WHERE p.hosp_number NOT in(SELECT number FROM shchyy_qg.tb_hosp)