Re: Suggestions on a good way to write an Update with a join

Hi,
Try using the Oracle8 feature for this.

Update THE( Select x, y, z , x1, y1 ,z1 from Table A , Table B where ...........)
Set x = x1 ,
y = y1,
z = z1

You should use the 'THE'.

For more information check the documentation.. ..../ORANT/doc/server803/A54641_01/ch4.htm.. Received on Tue May 18 1999 - 17:21:46 CDT