22,199
社区成员
发帖
与我相关
我的任务
分享
SELECT stu_id
FROM (kk.student, kk.course)
RIGHT JOIN kk.`notebook` ON not_stu_id = stu_id
WHERE stu_grp_id =36
AND note_date LIKE '%%'
GROUP BY not_id
SELECT stu_id,stu_grp_id,count( * )
FROM (kk.student, kk.course) RIGHT JOIN kk.`notebook` ON not_stu_id = stu_id --from这里语法实在没看懂
WHERE note_date LIKE '%%'
GROUP BY stu_id,stu_grp_id
SELECT count( * )
FROM (
SELECT stu_id
FROM kk.student,kk.course
RIGHT JOIN kk.notebook ON not_stu_id = stu_id
WHERE stu_grp_id =36
AND note_date LIKE '%%'
GROUP BY stu_id
) AS temp
SELECT count( * )
FROM (
SELECT stu_id
FROM kk.student,kk.course
RIGHT JOIN kk.notebook ON not_stu_id = stu_id
WHERE stu_grp_id =36
AND note_date LIKE '%%'
GROUP BY not_id
) AS temp
试试