mysql外连接

select e.empno,e.ename,d.dname

from dept d left outer join emp e

on e.deptno = d.deptno

where d.deptno = 40;