Query linking pairs preList: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→SQL) |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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 | 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 == | == 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 | 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. [[User:Ttenbergen|Ttenbergen]] 10:30, 2021 July 28 (CDT) | ||
== Related articles == | == Related articles == | ||
Latest revision as of 14:24, 2022 April 21
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: |