Unmatched Records in 2 Tables

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
 
C

CSmith

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
 
R

Rick

Build an unmatched query.

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