查询至少有一门课与学号为“01“的同学所学相同的同学的信息

建表语句点击详见

– 查询至少有一门课与学号为"01"的同学所学相同的同学的信息

SELECT DISTINCT st.* FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id WHERE sc.c_id IN ( SELECT sc2.c_id FROM student st2 LEFT JOIN score sc2 ON sc2.s_id=st2.s_id WHERE st2.s_id ='01' )