sc是table,s是编号,c是课程
select * from sc A left join sc B on A.s=B.s left join sc C on A.s=C.s where A.c=B.c and A.c=C.c (其余条件放Where后面)
sc是table,s是编号,c是课程
select * from sc A left join sc B on A.s=B.s left join sc C on A.s=C.s where A.c=B.c and A.c=C.c (其余条件放Where后面)