请帮忙解释一下，多表联查，小弟我看太不懂，谢啦
日期：2014-05-17 浏览次数：20466 次
请帮忙解释一下，多表联查，我看太不懂，，谢啦
------解决方案--------------------
- SQL code
select * from (select bookid,count(bookid) as degree from tb_borrow group by bookid) as borr join (select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left join tb_bookcase c on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id where b.del=0) as book on borr.bookid=book.id order by borr.degree desc limit 10
------解决方案--------------------
- SQL code
select * from
(
select bookid,count(bookid) as degree from tb_borrow group by bookid
)
as borr
join
(
select b.*,c.name as bookcasename,p.pubname,t.typename from tb_bookinfo b left join tb_bookcase c on b.bookcase=c.id join tb_publishing p on b.ISBN=p.ISBN join tb_booktype t on b.typeid=t.id where b.del=0
)
as book on borr.bookid=book.id order by borr.degree desc limit 10
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
