Student No, Name, ClassID, 1, ZDY, 2, 2, HUZ, 2, 3, YXX, 2, 4, SSS, 1,
ClassClassID, ClassName, 2, Y2002, 3, Y2003,
1.Select * from student, class where student.classid = Class.classidno, Name, ClassID, ClassID, ClassName, 1, ZDY, 2, 2, Y2002, 2, Huz, 2, 2, Y2002, 3, YXX, 2 , 2, Y2002,
2.Select * from student left join class on student.classid = Class.classidno, Name, ClassID, ClassID, Classname, 1, ZDY, 2, 2, Y2002, 2, Huz, 2, 2, Y2002, 3, YXX, 2, 2, Y2002, 4, SSS, 1,,,
3.Select * from student
Inner Join
Class on student.classid = Class.classidno, Name, ClassID, ClassID, ClassName, 1, ZDY, 2, 2, Y2002, 2, Huz, 2, 2, Y2002, 3, YXX, 2, 2, Y2002, 1
4.Select * from student right join class on student.classid = Class.classidno, Name, ClassID, ClassID, ClassName, 1, ZDY, 2, 2, Y2002, 2, Huz, 2, 2, Y2002, 3, YXX, 2, 2, y2002,,,, 3, y2003,
