Query linking pairs preList: Difference between revisions
Ttenbergen (talk | contribs) m →Log |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (2 intermediate revisions 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, | |||
FROM L_PHI | 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 == | ||