Re: Problem with update uses two tables

Waldemar Dacko wrote:
> Hi,
> 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. Please tell me what is wrong with this query
> and how to change it.
>
> WD

Look at the UPDATE demos in Morgan's Library at www.psoug.org and modify the one that will do what you wish.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org