Query linking pairs preList: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "Query linking_pairs_preList is a query in CFE that is used by Populate linking pairs for making linking_pairs table. == Related articles == {{Related Articles}}...") |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
Query linking_pairs_preList is a query in [[CFE]] that is used by [[Populate linking pairs]] for making [[linking_pairs table]]. | Query linking_pairs_preList is a query in [[CFE]] that is used by [[Populate linking pairs]] for making [[linking_pairs table]]. | ||
== SQL == | |||
See [[CFE]] for current version, but here is an instance: | |||
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 L_PHI | |||
GROUP BY L_PHI.PHIN | |||
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 == | |||
2021-07-28 - created query to replace hard coded SQL in VBA | |||
== Related articles == | == Related articles == |
Revision as of 10:26, 2021 July 28
Query linking_pairs_preList is a query in CFE that is used by Populate linking pairs for making linking_pairs table.
SQL
See CFE for current version, but here is an instance: 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 L_PHI GROUP BY L_PHI.PHIN 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
2021-07-28 - created query to replace hard coded SQL in VBA
Related articles
Related articles: |