Update table

SQL question:

Table test1 ( A,B,C,D,E,F) Table test2 (A,B,C,D)

I want to update column C and D from "test1" where test1.A=test2.A and test1.B=test2.B and (test1.C<>test2.C or test1.D<>test2.D).

Can someone help me?
Tanks Received on Mon Oct 27 1997 - 00:00:00 CST