Finding Differnces in Two Tables

[Adam]

I have two tables with linked 'Incident#'. I am trying to identify errors in
one of the tables. How do I create a query that identifies matching
'Incident#' with a different 'IncidentDate' between the two tables?

Thanks!

 

[Stefan Hoffmann]

hi Adam,

I have two tables with linked 'Incident#'. I am trying to identify errors in
one of the tables. How do I create a query that identifies matching
'Incident#' with a different 'IncidentDate' between the two tables?

Your queries SQL should look like this:

SELECT L.*, R.*
FROM yourTable1 L
INNER JOIN yourTable2 R
ON L.[Incident#] = R.[Incident#]
WHERE L.IncidentDate <> R.IncidentDate



mfG
--> stefan <--