1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| INSERT IGNORE INTO dicom.DICOMWorkList
(AccessionN, PatientID, PatientNam, PatientBir, PatientSex, StartDate, Modality, LastMenstr )
SELECT trc_dossier.code_trace_dossier, trc_dossier.code_patient,
CONCAT(glb_patient.nom, '^', glb_patient.prenom),
DATE_FORMAT(glb_patient.date_naissance,'%Y%m%d') ,
'F',
DATE_FORMAT(trc_dossier.date_entree,'%Y%m%d'),
'US',
DATE_FORMAT(sa_grossesse.date_derniere_regle,'%Y%m%d')
FROM gyndata.trc_dossier
INNER JOIN gyndata.glb_patient ON trc_dossier.code_patient = glb_patient.code_patient
INNER JOIN gyndata.sa_grossesse ON glb_patient.code_patient = sa_grossesse.code_patient
WHERE station IN ('STA_MAT_033', 'STA_MAT_019')
AND date_entree >=CURDATE()AND date_sortie IS Null;
INSERT IGNORE INTO dicom.DICOMWorkList ( AccessionN, PatientID, PatientNam, PatientBir, PatientSex, StartDate, Modality )
SELECT trc_dossier.code_trace_dossier, trc_dossier.code_patient,
CONCAT(glb_patient.nom, '^', glb_patient.prenom),
DATE_FORMAT(glb_patient.date_naissance,'%Y%m%d') ,
'F',
DATE_FORMAT(trc_dossier.date_entree,'%Y%m%d'),
'US' AS Expr3
FROM gyndata.trc_dossier
INNER JOIN gyndata.glb_patient ON trc_dossier.code_patient = glb_patient.code_patient
WHERE station IN ('STA_MAT_033', 'STA_MAT_019')
AND date_entree >=CURDATE()AND date_sortie IS Null; |
Partager