update problem

Hi all,

I have this, probably very easy to solve, problem to solve:

I am trying to update a talble using entries in another table.

TableA
colA colB colC

1        A        1
2        B        x
3        X        13

TableB
col1 col2

Z        123
H        223
B        323

now I want to update tableA ColC where tableAcolB = tableBcol1, in fact updating all rows from tableA which have entries in table B.

It seems to be unpossible using a subselect in a update... or am I wrong? (yep,... newbie)

Marc Received on Thu Jul 25 2002 - 18:45:22 CEST