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
Printable View
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
No you cannot, but you can do things like:
etc.Code: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