SQL语句去连接两个表，内连接，左连接以及右连接

1.查看两张表的情况，sc表和student表

select * from student;
select * from sc;

2.左连接和右连接的查询情况

select student.*,sc.* from student left join sc on student.sno=sc.sno;
 select student.*,sc.* from student right join sc on student.sno=sc.sno;

3.内连接

select student.*,sc.* from student join sc on student.sno=sc.sno;