Re: UPDATE with 2 tables

this should do it...

( assume one and only one fka matches each ida, else there will be an error)

update a set FA = (select FB from B where ida = fka);

"Stéphane lemoine" <lemoines_at_cybercable.fr> wrote:

>I have a problem
>
>there are 2 table A and B
>a (IDA, FA)
>b (IDB, FB, FKA)
>a is linked to b with IDA = FKA
>
>i want to update FA with the value of FB
>IDA = FKA
>
>i dont know how to write the SQL statement
>
>UPDATE a
>SET FA
>=(select...)
>
>please help me
>
>
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Fri Jun 02 2000 - 00:00:00 CEST