Query linking pairs preList: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(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}}...")
 
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: