完成四张excel表,分别是笛卡尔积表、内连接表、左连接表、右连接表。
1.笛卡尔积表查询代码select Student.Sno,Sname,Ssex,Sage,Sdept, SC.Sno,Cno,Grade
from Student cross join SC;

2.内连接查询代码select Student.Sno,Sname,Ssex,Sage,Sdept, SC.Sno,Cno,Grade
from Student inner join SC on SC.Sno=Student.Sno;

3.左连接查询代码select Student.Sno,Sname,Ssex,Sage,Sdept, SC.Sno,Cno,Grade
from Student left join SC on SC.Sno=Student.Sno;

4.右连接查询代码select Student.Sno,Sname,Ssex,Sage,Sdept, SC.Sno,Cno,Grade
from Student right join SC on SC.Sno=Student.Sno;

将查询结果导入到excel表格的方法:
1.先在结果框右键全选(也可以直接按CTRL+A)
2.再按一次右键,选择“连同标题一起复制”
3.CTRL+V粘贴到EXCEL表格的第一个单元格即可

配套数据库(文件):