Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with update uses two tables
> I've had a problem with (probably) simple query. I want to update one
> field in one table when another field in this table is equal to
> another field in another table (they have the same type of course).
> This should be something like this (each table has two field - id and
> x):
>
> update tabX set tabX.x = tabY.y where tabX.id = tabY.id
> but it doesn't working...
use:
UPDATE tabX set x=(SELECT y FROM tabY WHERE tabY.id=tabX.id) WHERE ...
I think You are newbie, so check Your syntax before use.
--- AWReceived on Wed Sep 12 2007 - 03:17:39 CDT