inner join update

[Cyrus]

i've used inner join to join 2 tables Table_A and Table_B, when I tried to update field only found in Table_A my application crashes.

is it possible to update flds whe two tables are joined ?

please advise

thanks
cyrus

[Bill Crawley]

No you cannot, but you can do things like:

Update Fred Set 
col1 = (select t1.col1 from Table1 t1 join Table2 t2 on t1.key = t2.key where t1.key = mykey),
col2 = (select t2.col1 from Table1 t1 join Table2 t2 on t1.key = t2.key where t1.key = mykey)
WHERE Mainkey = myKey

etc.