Query linking pairs preList
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: |