Finding Differnces in Two Tables

  • Thread starter Thread starter Adam
  • Start date Start date
A

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!
 
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?
Click to expand...
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 <--
 
Back
Top