请帮忙解释一下，多表联查，小弟我看太不懂，谢啦
程序员文章站
2022-06-04 23:41:38
...
请帮忙解释一下，多表联查，我看太不懂，，谢啦
------解决方案--------------------
- 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
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
相关文章
相关视频