数据关联正确性

-- 查询表名：诊疗活动信息表 (emr_activity_info) - 缺失患者基本信息关联排查
SELECT a.create_date AS "入库时间", a.id AS "诊疗活动信息表ID", a.patient_id AS "患者基本信息ID", a.patient_name AS "患者姓名", a.serial_number AS "就诊流水号"
FROM emr_activity_info a
WHERE a.create_date::DATE = '2026-07-23'::DATE AND a.org_code = '451123020'
  AND NOT EXISTS (
      SELECT 1 FROM emr_patient_info p WHERE p.id = a.patient_id
  )
ORDER BY a.create_date DESC