一条语句

[wankan]

三个表a,b,c
字段分别为
a:书、出版社
b:ID、出版社
c:书、出版社ID
怎样把每本书对应的出版社的ID填入到c表中的出版社ID中

[fengfangfang]

insert into c select a.书,b.ID from a inner join b where a.出版社=b.出版社

[wankan]

我在mysql里这样写不行的

[mathematician]

insert into c select a.书,b.ID from a inner join b on a.出版社=b.出版社

[fanyi2003]

insert into c select a.书,b.ID from a ,b where a.出版社=b.出版社

这样行不行?