17,377
社区成员
发帖
与我相关
我的任务
分享
select
o.organizename,course.c_coursename,u.realname
from sk_user_organize organize,sk_organize o,les_course course,les_courseaccess ca
,sk_user u
where organize.userid = ca.c_accessobjid
and organize.organizeid = o.organizeid
and ca.c_courseid = course.c_courseid
and ca.c_accessobjid = u.userid
order by o.organizename
select tt.organizename,count(distinct c_coursename),count(distinct realname)
(select o.organizename, course.c_coursename, u.realname
from sk_user_organize organize,
sk_organize o,
les_course course,
les_courseaccess ca,
sk_user u
where organize.userid = ca.c_accessobjid
and organize.organizeid = o.organizeid
and ca.c_courseid = course.c_courseid
and ca.c_accessobjid = u.userid
order by o.organizename)tt
group by tt.organizename