sql 查询多个表

直接黏贴sql cook book上的资料：

1  select ename as ename_and_dname, deptno
2    from emp
3   where deptno = 10
4   union all
5  select '----------', null
6    from t1
7   union all
8  select dname, deptno
9    from dept

 

select e.ename, d.loc
  from emp e inner join dept d
    on (e.deptno = d.deptno)
where e.deptno = 10