Query linking pairs out of sequence/linking pairs out of sequence deleter
Queries linking_pairs_out_of_sequence and linking_pairs_out_of_sequence_deleter are queries in CFE that are used by Populate linking pairs for making linking_pairs table.
SQL
See CFE for current version, but here is an instances.
query linking_pairs_out_of_sequence:
SELECT linking_pairs.PHIN, linking_pairs.early_D_ID, created_AdmitDtTm_early.Admit_DtTm, linking_pairs.late_D_ID, created_AdmitDtTm_late.Admit_DtTm FROM (linking_pairs INNER JOIN created_AdmitDtTm AS created_AdmitDtTm_early ON linking_pairs.early_D_ID = created_AdmitDtTm_early.D_ID) INNER JOIN created_AdmitDtTm AS created_AdmitDtTm_late ON linking_pairs.late_D_ID = created_AdmitDtTm_late.D_ID WHERE (((created_AdmitDtTm_early.Admit_DtTm)>[created_AdmitDtTm_late].[Admit_DtTm]));
query linking_pairs_out_of_sequence_deleter:
SELECT linking_pairs.PHIN, linking_pairs.early_D_ID, created_AdmitDtTm_early.Admit_DtTm, linking_pairs.late_D_ID, created_AdmitDtTm_late.Admit_DtTm FROM (linking_pairs INNER JOIN created_AdmitDtTm AS created_AdmitDtTm_early ON linking_pairs.early_D_ID = created_AdmitDtTm_early.D_ID) INNER JOIN created_AdmitDtTm AS created_AdmitDtTm_late ON linking_pairs.late_D_ID = created_AdmitDtTm_late.D_ID WHERE (((created_AdmitDtTm_early.Admit_DtTm)>[created_AdmitDtTm_late].[Admit_DtTm]));
Log
2021-08-03 query created as part of post Access 2019 fix for linking
Related articles
Related articles: |