6查询学过001并且也学过编号002课程的同学的学号姓名

2025-01-18 02:54:39

拼音 [ 拼音 ]

...001”并且也学过编号“002”课程的同学的学号、姓名) - souldom...

6、查询学过“001”并且也学过编号“002”课程的同学的学号、姓名: SELECTst.SId, st.StuNameFROM(SELECTt1.SIdASSIdFROM(SELECTs1.SIdFROMsc s1WHEREs1.CId='001')t1, (SELECTs2.SIdFROMsc s2WHEREs2.CId='002')t2WHEREt1.SId=t2.SId )stu, student stWHEREstu.SId=st.SId 在MySQL命令行中的运行...
...001”并且也学过编号“002”课程的同学的学号、姓名) - souldom...

6、查询学过“001”并且也学过编号“002”课程的同学的学号、姓名: SELECTst.SId, st.StuNameFROM(SELECTt1.SIdASSIdFROM(SELECTs1.SIdFROMsc s1WHEREs1.CId='001')t1, (SELECTs2.SIdFROMsc s2WHEREs2.CId='002')t2WHEREt1.SId=t2.SId )stu, student stWHEREstu.SId=st.SId 在MySQL命令行中的运行...