>Al alternative if what you really wanted was the two tables merged without any duplicates would be to UNION them together then do a GROUP BY on every field in the table. The result is all records from both tables without duplicates.
Isn't the default union clause distinct? That is to say, it only grabs one record if there are two or more dups?
>
>>I have pulled data from two separate SQL tables, and I need to find which rows are different. They have exactly the same structure.
>>
>>I have the two views which I will call cFirstSQL and cSecondSQL and I did the following thinking that this would work;
>>
>>SELECT * from cFirstSQL WHERE NOT EXSISTS (SELECT * FROM cSecondSQL)
>>
>>I get not data, and there are differences.
--Todd Sherman
-Wake Up! Smell the Coffee!