关于多表查询
SELECT student.name,college.collegeName FROM student INNER JOIN college ON student.collegeId = college.collegeId;
SELECT student.name,college.collegeName FROM student LEFT OUTER JOIN college ON student.collegeId = college.collegeId;
SELECT s.name,c.collegeName FROM student AS s INNER JOIN college AS c ON s.collegeId = c.collegeId;