数据库联表查询sql语句

最新推荐文章于 2024-07-22 19:21:18 发布

weixin_33827965

最新推荐文章于 2024-07-22 19:21:18 发布

阅读量733

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/xqt1010/archive/2008/07/22/1248393.html

版权

string tempsql2 = "select a.tid,a.click,b.newsId,b.newstitle,b.addate "
+ " from Tdayclick a inner join ncar_news b on a.tid = b.newsid where a.type = 1 and a.adddate = " + yday + " order by a.click desc";

string tempsql4 = "SELECT c.newsId, c.newsTitle,c.adddate, d.snum "
                + " FROM ncar_News c INNER JOIN "
                + "           (SELECT a.tid, a.click + b.tnum AS snum "
                + "          FROM (SELECT tid, click "
                + "                  FROM TDayClick "
                + "                  WHERE (type = 1) AND (adddate = " + YDay + ")) a INNER JOIN "
                + "                    (SELECT tid, COUNT(*) AS tnum "
                + "                   FROM TClick "
                + "                   WHERE (type = 1) "
                + "                   GROUP BY tid) b ON a.tid = b.tid) d ON c.newsId = d.tid "
                + " WHERE (c.isDelete = 0) OR "
                + "       (c.isDelete IS NULL) "
                + " ORDER BY d.snum DESC ";

转载于:https://www.cnblogs.com/xqt1010/archive/2008/07/22/1248393.html