复杂的连表查询，求大神指导

[u011462381]

我想把orderbook表里的bookid，quantity查出来（bookid相同的quantity相加起来），
然后再一起和books表里的title显示出来，请问怎么办

[昵称90天可改一次]

都正解 蹭分

[發糞塗牆]

select a.*,b.title
from 
(select bookid,sum(quantity)quantity
from orderbook
group by bookid)a inner join books b on a.bookid=b.bookid

[allan4062]

select a.*,b.title from books as b
left join (select bookid,sum(quantity) as sumQuantity from orderbook group by bookid) as a
on a.bookid=b.bookid