Update question

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 Received on Thu Jun 04 1998 - 09:15:15 CDT