内连接
inner join 子句连接查询
seelct * from student s inner join sc c on s.sno=c.cno;
左外连接
left join 子句连接查询
seelct * from student s left join sc c on s.sno=c.cno;
右外连接
seelct * from student s right join sc c on s.sno=c.cno;
全外连接
full outer join 子句
select s.,c. from student as s full outer join sc as c on s.sno=c.sno
自连接
就是自己连接自己,看示例查出上级名字
SELECT e1.*,e2.ename 上级
FROM emp e1
INNER JOIN emp e2
ON e1.empno
=e2.mgr
注意:
左外连接和右外连接是列出左表/右表所有的符合搜索的列的行数据