SELECT conclusiontype_name, COUNT(DISTINCT PeisPatient.id_patient) 实际体检人数 FROM PeisOrgReservationPatient INNER JOIN PeisOrgReservation ON PeisOrgReservationPatient.ID_OrgReservation=PeisOrgReservation.ID_OrgReservation JOIN PeisPatient ON PeisOrgReservationPatient.ID_Patient=PeisPatient.ID_Patient JOIN PeisPatientConclusion ON PeisOrgReservationPatient.ID_Patient=PeisPatientConclusion.ID_Patient WHERE PeisOrgReservation.ID_OrgReservation IN (689, 690, 691, 745, 692, 693, 694,695, 696, 697, 698, 699, 700, 701) AND (PeisPatient.conclusion IS NOT NULL OR peispatient.suggestion IS NOT NULL) AND PeisPatient.dateregister IS NOT NULL AND PeisPatient.sex='男' AND ConclusionType_Name=1 GROUP BY conclusiontype_name HAVING COUNT(DISTINCT PeisPatient.id_patient)=1
SELECT conclusiontype_name, COUNT(DISTINCT PeisPatient.id_patient) 实际体检人数 FROM PeisOrgReservationPatient INNER JOIN PeisOrgReservation ON PeisOrgReservationPatient.ID_OrgReservation=PeisOrgReservation.ID_OrgReservation JOIN PeisPatient ON PeisOrgReservationPatient.ID_Patient=PeisPatient.ID_Patient JOIN PeisPatientConclusion ON PeisOrgReservationPatient.ID_Patient=PeisPatientConclusion.ID_Patient WHERE PeisOrgReservation.ID_OrgReservation IN (689, 690, 691, 745, 692, 693, 694,695, 696, 697, 698, 699, 700, 701) AND (PeisPatient.conclusion IS NOT NULL OR peispatient.suggestion IS NOT NULL) AND PeisPatient.dateregister IS NOT NULL AND PeisPatient.sex='男' AND ConclusionType_Name='健康' GROUP BY conclusiontype_name HAVING COUNT(DISTINCT PeisPatient.id_patient)=1
conclusiontype_name, COUNT(DISTINCT PeisPatient.id_patient) 实际体检人数
FROM
PeisOrgReservationPatient
INNER JOIN PeisOrgReservation ON PeisOrgReservationPatient.ID_OrgReservation=PeisOrgReservation.ID_OrgReservation
JOIN
PeisPatient ON PeisOrgReservationPatient.ID_Patient=PeisPatient.ID_Patient
JOIN
PeisPatientConclusion ON PeisOrgReservationPatient.ID_Patient=PeisPatientConclusion.ID_Patient
WHERE
PeisOrgReservation.ID_OrgReservation IN (689, 690, 691, 745, 692, 693, 694,695, 696, 697, 698, 699, 700, 701)
AND
(PeisPatient.conclusion IS NOT NULL
OR
peispatient.suggestion IS NOT NULL)
AND PeisPatient.dateregister IS NOT NULL
AND PeisPatient.sex='男'
AND ConclusionType_Name=1
GROUP BY
conclusiontype_name
HAVING COUNT(DISTINCT PeisPatient.id_patient)=1
conclusiontype_name, COUNT(DISTINCT PeisPatient.id_patient) 实际体检人数
FROM
PeisOrgReservationPatient
INNER JOIN PeisOrgReservation ON PeisOrgReservationPatient.ID_OrgReservation=PeisOrgReservation.ID_OrgReservation
JOIN
PeisPatient ON PeisOrgReservationPatient.ID_Patient=PeisPatient.ID_Patient
JOIN
PeisPatientConclusion ON PeisOrgReservationPatient.ID_Patient=PeisPatientConclusion.ID_Patient
WHERE
PeisOrgReservation.ID_OrgReservation IN (689, 690, 691, 745, 692, 693, 694,695, 696, 697, 698, 699, 700, 701)
AND
(PeisPatient.conclusion IS NOT NULL
OR
peispatient.suggestion IS NOT NULL)
AND PeisPatient.dateregister IS NOT NULL
AND PeisPatient.sex='男'
AND ConclusionType_Name='健康'
GROUP BY
conclusiontype_name
HAVING COUNT(DISTINCT PeisPatient.id_patient)=1