类别查询父节点标题 sql

最新推荐文章于 2025-08-12 23:49:52 发布

原创最新推荐文章于 2025-08-12 23:49:52 发布 · 447 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#join #sql #c

SQL 专栏收录该内容

2 篇文章

订阅专栏

/* public SqlDataReader GetUserNeedsByUserResType(int userResType,int pageIndex) { this.OpenConn(); this.Comm.CommandText = "select top 20 * from Questions C, (select A.ID as ID,A.PID AS PID,A.TITLE AS TITLE,B.Title as PTitle from Category A left join Category B ON A.PID=B.ID where A.PID=B.ID) D where C.type=D.ID and C.type=" + userResType + " and C.questionID not in (select top " + pageIndex * 20 + " C.questionID from Questions C, (select A.ID as ID,A.PID AS PID,A.TITLE AS TITLE,B.Title as PTitle from Category A left join Category B ON A.PID=B.ID where A.PID=B.ID) D where C.type=D.ID and C.type=" + userResType + " order by questionTime desc) order by questionTime desc"; return this.Comm.ExecuteReader(CommandBehavior.CloseConnection); }*/ --select A.ID as ID,A.PID AS PID,A.TITLE AS TITLE,B.Title as PTitle from Category A left join Category B ON A.PID=B.ID select *,C.title as questionTitle from Questions C, (select A.ID as ID,A.PID AS PID,A.Title AS Title,B.Title as PTitle from Category A left join Category B ON A.PID=B.ID where A.PID=B.ID) D where C.type=D.ID and C.type=63