-- 9、查询学过编号为“01“并且也学过编号为“02“的课程的同学的信息

科技2022-07-20 105

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

Processed: 0.008, SQL: 8