Query of uncommon records...

  • Thread starter Thread starter Hydrogeo
  • Start date Start date
H

Hydrogeo

I am having some trouble writing a query where I can match records with
similar but exactly the same content. For example I want to watch times with
second or five second differences... What is the best way for me to do this?
 
I am having some trouble writing a query where I can match records with
similar but exactly the same content. For example I want to watch times with
second or five second differences... What is the best way for me to do this?
Click to expand...

Use a "non equi join". For the exact ecample you cite:

SELECT TableA.*, TableB.*
FROM TableA, TableB
WHERE Abs(DateDiff("s", [TableA].[TimeA], [TableB].[TimeB]) < 5;

This query won't be updateable and it will be slow!
 
Back
Top