orcale 多表关联查询

orcale 中表的别名不使用AS而是直接空格在后面加上别名即可，

select a.empno as 员工编号, a.ename as 员工名称, b.dname as 部门
  from scott.emp a left outer join  scott.dept b
 on (a.deptno = b.deptno and b.dname like 'SALES') where b.dname like 'SALES'