SQL Help

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 - 11:27:28 CST