摘要： 内连接 select e.empno as 员工编号, e.ename as 员工名字, d.dname as 部门名字from emp e inner join dept d on e.deptno=d.deptno where e.deptno=10; 左连接 select e.empno as 阅读全文