Re: SQL Help

Try:

update table1 outer
set description =
 (select description

     from table2 inner
    where outer.description = inner.description

        and outer.id = inner.id
 );

Suresh

Chris Forlano <cforlano_at_nortelnetworks.com> wrote in article <38304280.98C1E111_at_nortelnetworks.com>...
> I'm trying to update the value of a cell in one table to be the value of
> a cell in another table.
>
> I've tried something like this:
>
> update table1 a, table2 b
> set a.description = b.description
> where a.id = b.id;
>
> However, UPDATE doesn't seem too keen on accepting two tables in the
> syntax?
>
> How can I do this?
>
> Thanks,
>
> Chris
> --
> Chris Forlano
> Automation Development
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
>
>
>
Received on Mon Nov 15 1999 - 12:15:57 CST