UPDATE with 2 tables
From: (wrong string) éphane lemoine <lemoines_at_cybercable.fr>
Date: 2000/06/02
Message-ID: <8h90rm$13s$1_at_news6.isdnet.net>#1/1
Date: 2000/06/02
Message-ID: <8h90rm$13s$1_at_news6.isdnet.net>#1/1
[Quoted] I have a problem
there are 2 table A and B
a (IDA, FA)
b (IDB, FB, FKA)
[Quoted] 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 Received on Fri Jun 02 2000 - 00:00:00 CEST