请帮忙解释一下，多表联查，小弟我看太不懂，谢啦

程序员文章站 2022-06-03 17:29:44

...

请帮忙解释一下，多表联查，我看太不懂，，谢啦

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核实处理。