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:

Populate linking pairs (← links)