select a.书名, b.publishername as 原出版社, c.upblishername as 出版社 from A left join B on a.oldupblisherid=b.publisherid left join B c on a.upblisherid=c.publisherid
还可以这样: select a.书名,c.publishername as 原出版社,d.publishername as 出版社 from a,(select * from b) c,(select * from b) d where a.oldpublisherid = c.publisherid and a.publisherid = d.publisherid
还可以 select a.书名,c.publishername as ,d.publishername as from a, (select * from b) c,c as d where a.oldpublisherid=c.pulisherid and a.publisherid=d.publisherid
select a.书名,c.publishername as 原出版社,d.publishername as 出版社 from a,(select * from b) c,(select * from b) d where a.oldpublisherid = c.publisherid and a.publisherid = d.publisherid
select a.书名,c.publishername as ,d.publishername as from a,
(select * from b) c,c as d where a.oldpublisherid=c.pulisherid and
a.publisherid=d.publisherid