need help with syntax

need help with syntax

am 20.02.2006 15:43:19 von Nick Wedd

I have an old table, with fields called 'description' and 'program_id'.
I have a new table, with fields called 'description' and 'id'.

For the values (10,69,39,85), I want to get the value of 'description'
from the old table record with that program_id, and stuff it into the
'description' field of the record of the new table that has that same
id.

I have been thrashing about with things like
UPDATE new_table
SET description = SELECT old_table.description
FROM old_table,new_table
WHERE new_table.id = old_table.program_id
AND old_table.program_id IN ( 10,69,39,85 );
and can find nothing that works.

Can someone please help?

Nick
--
Nick Wedd nick@maproom.co.uk