Re: [SQL] How to add column from old_table to new_table?

[Gnanavel S]

On 9/21/05, Joost Kraaijeveld <[EMAIL PROTECTED]> wrote:

Hi,

I made a mistake in describing the query I tried. The query I tried was:

update new_table
set new_attribute = (select old_attribute from old_table, new_table
where old_table.id = new_table.id)
where old_table.id = new_table.id

It should be written has

update new_table set new_attribute=old_attribute from old_table where old_table.id=new_table.id;

It actually returns the error "ERROR:  more than one row returned by a
subquery used as an _expression_" if ran.


--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: [EMAIL PROTECTED]
web: www.askesis.nl





---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--
with regards,
S.Gnanavel
Satyam Computer Services Ltd.