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.PHIN, 
       created_AdmitDtTm.Admit_DtTm,  
       L_PHI.D_ID,  
       linking_pairs_LatestLinkedPHINAdmit.D_ID
FROM (linking_pairs_multis  
       INNER JOIN ((L_PHI 
                    INNER JOIN created_AdmitDtTm  
                        ON L_PHI.D_ID = created_AdmitDtTm.D_ID)  
       LEFT JOIN linking_pairs_LatestLinkedPHINAdmit  
           ON L_PHI.D_ID = linking_pairs_LatestLinkedPHINAdmit.D_ID)  
           ON linking_pairs_multis.PHIN = L_PHI.PHIN)  
       INNER JOIN linking_pairs_unlinkeds  
           ON L_PHI.D_ID = linking_pairs_unlinkeds.D_ID
WHERE (((linking_pairs_LatestLinkedPHINAdmit.D_ID) Is Not Null))  
       OR (((linking_pairs_unlinkeds.D_ID) Is Not Null))
ORDER BY L_PHI.PHIN, created_AdmitDtTm.Admit_DtTm;

Log

2021-07-28 - created query to replace hard coded SQL in VBA, both to fix linking pairs that took way longer in Access 2019 than it had in 2010, and to start using Service tmp entry dates rather than old Arrive DtTm field, when available. Ttenbergen 10:30, 2021 July 28 (CDT)

Related articles

Related articles:

Populate linking pairs (← links)