--查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息 select*fromstudentwheres_idin(selectt1.s_idfromscore t1, score t2wheret1.s_id=t2.s_idandt1.c_id='01'andt2.c_id='02'); selecta.*fromstudent a, score b, score cwherea.s_id=b.s_idanda.s_id=c.s_idandb.c_id...
--查询学过编号为"01"并且也学过编号为"02"的课程的同学的信息 select*fromstudentwheres_idin(selectt1.s_idfromscore t1, score t2wheret1.s_id=t2.s_idandt1.c_id='01'andt2.c_id='02'); selecta.*fromstudent a, score b, score cwherea.s_id=b.s_idanda.s_id=c.s_idandb.c_id...