Join query of SQL statements)
Student
No such name already classid used ‚
1 Gbit/s zdy then 2 Gbit/s ‚
2 bytes huz limit 2 bytes ‚
3 ‚ yxx limit 2 then ‚
4 ipvsss then 1 then ‚
Class
Classid implements classname Authentication ‚
2 ‚ y2002 Branch ‚
3 ‚ y2003 restart ‚
1. Select * from student into class where student. classid = Class. classid
No such name has classid has classname has ‚
1 ‚ zdy limit 2 then 2 policy2002 limit ‚
2 seconds huz done 2 seconds 2 seconds y2002 seconds ‚
3. policyxx limit 2 limit 2 policy2002 limit ‚
2. Select * from student left join class on student. classid = Class. classid
No such name has classid has classname has ‚
1 ‚ zdy limit 2 then 2 policy2002 limit ‚
2 seconds huz done 2 seconds 2 seconds y2002 seconds ‚
3. policyxx limit 2 limit 2 policy2002 limit ‚
4. Sss Serial 1 packet loss ‚‚‚
3. Select * from student Inner join Class on student. classid = Class. classid
No such name has classid has classname has ‚
1 ‚ zdy limit 2 then 2 policy2002 limit ‚
2 seconds huz done 2 seconds 2 seconds y2002 seconds ‚
3. policyxx limit 2 limit 2 policy2002 limit ‚
The result is the same as 1.
4. Select * from student right join class on student. classid = Class. classid
No such name has classid has classname has ‚
1 ‚ zdy limit 2 then 2 policy2002 limit ‚
2 seconds huz done 2 seconds 2 seconds y2002 seconds ‚
3 ‚ yxx limit 2 limit 2 policy2002Bytes ‚
Please wait until 3 then y2003 then ‚