首頁 > 後端開發 > php教程 > 请帮忙解释一下,多表联查,小弟我看太不懂,谢啦

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

WBOY
發布: 2016-06-13 13:41:35
原創
1178 人瀏覽過

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

SQL code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->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 <div class="clear">
                 
              
              
        
            </div>
登入後複製
相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板