Re: Update question

On Thu, 04 Jun 1998 09:15:15 -0500, "Linda K. Johnson" <lkjohnson_at_lctx.com> wrote:

>Is there a way to update one table with selected fields from another
>table? The only way we see (and it doesn't work) requires trying to
>return more than one row to the set statement.
>
>i.e.
> update table1
> set column1=(select feature from table2, table3
> where table2.column2=table3.column2)
>
>It returns too many rows to the update. Thanks for any help.
>
>Please send any responses to pacosta_at_lctx.com or the newsgroup.
>
>
>Thanks again,
>
>Paul Acosta
>
>

Please give a more detailed description of what you want to update. I've already done several updates to one table using information from others, but I was selecting only one row for each row to be updated. The table I was updating was correlated in the select clause.

If you give a more detailed description, I'll write the update statement for you.

Nuno Guerreiro Received on Thu Jun 04 1998 - 09:58:01 CDT