Query of uncommon records...

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?
 
J

John W. Vinson

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!
 
Top