Comparing duplicate tables for missing records

[rarubio1]

Table tblWO2 is a duplicate of tblWO1. Today I discovered that some of the work orders in tblWO1 do not exist in tblWO2. What query can I run to figure out which work orders exist in tblWO1 and not in tblWO2.

Thank,
RR

 

[ESquared]

SELECT Column1, Column2, Column3
   FROM tblW02 W2 LEFT JOIN tblW01 W1 ON W2.WONum = W1.WONum
   WHERE W1.WONum IS NULL

 

[SQLSister]

Create a left join between the two tables.
Then put in the where clause where tblWO2.ID is null

 

[ESquared]

Have you ever seen such fighting to answer people's questions and be helpful? Why can't it be more like this at the post office?

 

[rarubio1]

Thanks a bunch guys for your suggestions.

RR

 

[ESquared]

Make sure you check for missing records the other direction, too.