Svein Erling Tysvaerwrote:

> > update TableA a
> > set a.p=(select b.q from TableB b where b.y=a.x)
> > where exists(select * from TableB c where c.y=a.x)

Is also possible to use this syntax if more than 1 column need changes,
eg.
update a set a.p=b.q, a.r=b.s from a, b where a.x=b.y

regards,
bill