题目内容
（请给出正确答案）
提问人：网友kingwho
发布时间：2022-01-07
[主观题]
存在两张表Students（ID，Name，CollegeID#）和Colleges（ID，Name，Address），如果要查询出（StudentID，StudentName，CollegeName）的结果，SQL语句是
A、SELECT s.ID AS StudentID，s.Name AS StudentName，c.Name AS CollegeName FROM Students s JOIN Colleges c ON s.ID = c.ID
B、SELECT c.ID AS StudentID，s.Name AS StudentName，c.Name AS CollegeName FROM Students s JOIN Colleges c ON s.ID = c.ID
C、SELECT s.ID AS StudentID，s.Name AS StudentName，c.Name AS CollegeName FROM Students s JOIN Colleges c ON s.CollegeID = c.ID
D、SELECT c.ID AS StudentID，s.Name AS StudentName，c.Name AS CollegeName FROM Students s JOIN Colleges c ON s.CollegeID = c.ID
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
抱歉！暂无答案，正在努力更新中……
