Query linking pairs preList: Difference between revisions
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) m →SQL |
||
| Line 3: | Line 3: | ||
== SQL == | == SQL == | ||
See [[CFE]] for current version, but here is an instance: | See [[CFE]] for current version, but here is an instance: | ||
SELECT L_PHI.D_ID, L_PHI_moreThanOne.PHIN, created_AdmitDtTm.Admit_DtTm | SELECT L_PHI.D_ID, L_PHI_moreThanOne.PHIN, created_AdmitDtTm.Admit_DtTm | ||
FROM ((SELECT L_PHI.PHIN, Count(L_PHI.D_ID) AS CountOfD_ID | FROM (( | ||
FROM L_PHI | SELECT L_PHI.PHIN, Count(L_PHI.D_ID) AS CountOfD_ID | ||
GROUP BY L_PHI.PHIN | FROM L_PHI | ||
HAVING (((Count(L_PHI.D_ID))>1)) | GROUP BY L_PHI.PHIN | ||
ORDER BY Count(L_PHI.D_ID)) AS L_PHI_moreThanOne INNER JOIN L_PHI ON L_PHI_moreThanOne.PHIN = L_PHI.PHIN) INNER JOIN created_AdmitDtTm ON L_PHI.D_ID = created_AdmitDtTm.D_ID; | HAVING (((Count(L_PHI.D_ID))>1)) | ||
ORDER BY Count(L_PHI.D_ID)) AS L_PHI_moreThanOne | |||
INNER JOIN L_PHI ON L_PHI_moreThanOne.PHIN = L_PHI.PHIN) INNER JOIN created_AdmitDtTm ON L_PHI.D_ID = created_AdmitDtTm.D_ID; | |||
== Log == | == Log == | ||