1. SELECT
  2. e.ename, d.dname, d.loc
  3. FROM emp e, dept d
  4. WHERE e.deptno = d.deptno
  5. AND e.deptno = 10;
  1. SELECT
  2. e.ename, d.dname, d.loc
  3. FROM emp e INNER JOIN dept d
  4. ON e.deptno = d.deptno
  5. WHERE e.deptno = 10;