|
|
Archives of the TeradataForum
Message Posted: Fri, 16 Sep 2005 @ 15:07:01 GMT
Subj: | | Re: Compare rows of tableA to rows of tableB - HOW? |
|
From: | | Victor Sokovin |
| I have a question that may not have the answer I'm looking for. The age-old question - I have TableA and TableB, they have an identical
set of columns (C1, C2, C3). I want to identify the rows in TableA that are different than the rows in TableB. | |
It sounds like you could use set operators such as MINUS (ALL) or INTERSECT (ALL).
Regards,
Victor
| |