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

  1. select a.* from

  2. student a,score b,score c

  3. where a.s_id = b.s_id and a.s_id = c.s_id and b.c_id='01' and c.c_id='02'

版权声明：本文为weixin_60715943原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。