UPDATE table1 INNER JOIN table2 ON table1.id = table2.id SET table1.fname = table2.fname这个是不是access的写法啊,要是这样,能不能这样啊UPDATE table1 INNER JOIN table2 ON table1.id = table2.id
SET table1.fname = iif(table2.fname=null,'',table2.fname)要是sql server里,则update table1 set table1.fname=case when table2.fname is null then '' else table2.fname
end from table2 where table1.id=table2.id
SET table1.fname = iif(table2.fname=null,'',table2.fname)要是sql server里,则update table1 set table1.fname=case when table2.fname is null then '' else table2.fname
end from table2 where table1.id=table2.id
from table1 a join table2 b on a.id=b.id
UPDATE table1 INNER JOIN table2 ON table1.id = table2.id
SET table1.fname = iif(table2.fname=null,'',table2.fname)看来只能换个方法搞了!3.....