补充B表要插入的字段是统计出来的
我这样:
insert into A(Booknum) select sum(Booknum) from B group by Bookid
where A.Bookid=B.Bookid抱错说:Where附近有语法错误。
请问该如何写???
我这样:
insert into A(Booknum) select sum(Booknum) from B group by Bookid
where A.Bookid=B.Bookid抱错说:Where附近有语法错误。
请问该如何写???
where A.Bookid=B.Bookid