两条数据完全没有差异
1、在mysql客户端运行:
select tbl_adt_admits_discharges.* from etldr2125.tbl_adt_admits_discharges inner join etldr21252023_08_14.pid_table on tbl_adt_admits_discharges.patient_id = etldr21252023_08_14.pid_table.patient_id where etldr2125.tbl_adt_admits_discharges.yidu_t1_removed = ‘0’ or (etldr2125.tbl_adt_admits_discharges.yidu_t1_removed is null and etldr21252023_08_14.pid_table.patient_id=‘xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx’);
如果 select distinct 就是1条。