UC知道求多表连接查询SQL语句
来源：百度知道 编辑：UC知道 时间：2024/06/04 01:03:08
两表：user和news
user字段：ID,uname
news字段：ID,title,content,uname
两表相关联的字段：uname
现查询所有user的数据，按其发布的新闻条数排序
谢谢！！
SELECT c.*,m.M_Province,m.M_Tel,m.M_userID,m.M_City,m.M_Habitus,b.B_Count FROM Asean_Company c INNER JOIN Asean_Member m ON c.C_userID=m.M_userID INNER JOIN (select count(ID) AS B_Count from Asean_Productscn) b ON c.C_userID=b.P_userID WHERE m.M_Habitus=999 ORDER BY b.B_Count DESC,c.ID DESC
user字段：ID,uname
news字段：ID,title,content,uname
两表相关联的字段：uname
现查询所有user的数据，按其发布的新闻条数排序
谢谢！！
SELECT c.*,m.M_Province,m.M_Tel,m.M_userID,m.M_City,m.M_Habitus,b.B_Count FROM Asean_Company c INNER JOIN Asean_Member m ON c.C_userID=m.M_userID INNER JOIN (select count(ID) AS B_Count from Asean_Productscn) b ON c.C_userID=b.P_userID WHERE m.M_Habitus=999 ORDER BY b.B_Count DESC,c.ID DESC
select a.* from user a inner join (select uname,count(uname) as num from news group by uname) b on a.uname=b.uname
order by b.num
select a.* from (select ID,uname,count(*) count from news) a order by
a.count desc
第一个user表也没什么用啊，它有的第二个表都有了