56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT pp.toyear, pp.grouptypeid, pp.subjectid, se. *
FROM djs_skpaper AS pp, djs_skexam AS se
WHERE se.grouptypeid =1
AND se.subjectid =1
AND se.grouptypeid = pp.grouptypeid
ORDER BY pp.toyear DESC
LIMIT 0 , 30
SELECT pp.toyear, pp.grouptypeid, pp.subjectid, se. *
FROM djs_skpaper AS pp INNER JOIN djs_skexam AS se ON se.grouptypeid = pp.grouptypeid
WHERE se.grouptypeid =1
AND se.subjectid =1
ORDER BY pp.toyear DESC
LIMIT 0 , 30
建议好好看一下MYSQL连接查询部分 !