|  |  | Archives of the TeradataForumMessage 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 
 
 |  |