Unmatched Records in 2 Tables

  • Thread starter Thread starter peternunez
  • Start date Start date
P

peternunez

I have two tables that should be the same. But the first
table has 252 records more than the 2nd table. Their
identical in structure and data. How do I isolate the 252
records? There are three fields that make each record
unique, Session, Line and UserID.

Any help would be appreciated.

Thanks, Peter
 
Hi,
the first table has 252 records more
than the 2nd table. Their identical in structure
and data. How do I isolate the 252 records?
There are three fields that make each record
unique, Session, Line and UserID.
Click to expand...

Perhaps the following will help:

Select Session, Line, UserID From tblFirstTable
Left Join
tblSecondTable On tblFirstTable.Session = tblSecondTable.Session
And tblFirstTable.Line = tblSecondTable.Line
And tblFirstTable.UserID = tblSecondTable.UserID
Where tblSecondTable.Session Is Null
Or tblSecondTable.Line Is Null
Or tblSecondTable.UserID Is Null
 
Build an unmatched query.

In the query section, click 'new' and then select the unmatched query
wizard. it will walk you through the steps.
 
Back
Top