|
View previous topic :: View next topic
|
| Author |
Message |
aryanpa1
New User
Joined: 26 May 2007
Posts: 45
Location: Chennai
|
|
|
|
Hi Team,
Below are the fileds on Table A and Table B.
Column1 --- DECIMAL(7,0)
Column2 ---CHAR(2)
Column3 --- DECIMAL(5,0)
Column4 --- CHAR(3)
Column5 --- DECIMAL(3,0)
Column1 to Column5 together form a key on both Table A and Table B.
My requirement is to unload only rows from TableA which are not matching with Table B for the columns Column1 to Column5. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| search the forum for compare tables. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
or probably easier,
look thru all of posts by GuyC. |
|
| Back to top |
|
|
|
|
