MySQL 查询结果取交集的实现方法

1 MySQL中如何实现以下SQL查询 (SELECT S.Name FROM STUDENT S, TRANSCRIPT T WHERE S.StudId = T.StudId AND T.CrsCode = ‘CS305’) INTERSECT (SELECT S.Name FROM STUDENT S, TRANSCRIPT T WHERE S.StudId = T.StudId AND T.CrsCode = ‘CS315’) 请各位不吝赐教,小弟先谢过~ 解: 取交集 select a.* from ( SELECT S.Name FROM STUDENT S, TRANSCRIPT