好复杂的语句

[wankan]

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

[xluzhong]

update c
set 出版社ID=b.id
from c
inner join a on c.书=a.书
inner join b on a.出版社=b.出版社

[lsxaa]

update c set 出版社ID=b.id
from a ,b
where c.书=a.书 and a.书=b.书

[lsxaa]

update c set 出版社ID=b.id
from a ,b
where c.书=a.书 and a.出版社=b.出版社

[edgethinking]

update c set 出版社ID = t1.出版社 from (select * from a union all select * from b) t1
where c.书 = t1.书

[tdtjjiao]

update c set 出版社ID=b.id
from a ,b
where c.书=a.书 and a.书=b.书

[wankan]

上面试过了没一个对的.大家看清楚表里的字段吧.
忘记说了,这是mysql.