如果有关联字段IDupdate b set b.userid = a.userid b.password = a.password from a,b where a.id = b.id如果没有. insert into b(userid,password) select userid,password from a where ........
insert into customer(custid,fmoney) select UserID,UserMoney from user where userid>0 说USER附近有语法错误
对不起,突然想起USER是关健:) 加上[]即可:)谢谢
insert into A(Col1,Col2...) select Col1,Col2,... from Ba
set b.userid = a.userid
b.password = a.password
from a,b
where a.id = b.id如果没有.
insert into b(userid,password) select userid,password from a where ........
select Col1,Col2,...
from Ba