update, select and join in one statement ?

Hello everybody !

I try to build a statement like this:

update table1
set table1.columnA=table2.columnA
where table1.columnB=table2.columnB

Is something like this possible? I just don't get it right. What I want is to "copy" the information of table2.columnA into table1.columnA, but only if there is a join on the columns B possible for the row that is to be updated.

--
Michael Keppler, MCSE
IT logic GbR
Michael.Keppler_at_gmx.de Received on Sat Aug 28 1999 - 14:49:28 CDT