SQL & PL/SQL

I don't have access to create tables at work - just to run selects on existing tables.

I've used the SQL below to use the 2 standard Oracle test dept and emp tables for testing, but - is it possible to use SQL to join the tables, or can the GET table WITH table AS ... SQL only ever work on one table at a time, rather than allowing joins to be done?

Thanks

GET dept
WITH dept AS
     (SELECT 10 deptno
           , 'ACCOUNTING ' dname
           , 'NEW YORK' loc
        FROM DUAL
      UNION ALL
      SELECT 20 deptno
           , 'RESEARCH   ' dname
           , 'DALLAS' loc
        FROM DUAL
      UNION ALL
      SELECT 30 deptno
           , 'SALES      ' dname
           , 'CHICAGO' loc
        FROM DUAL
      UNION ALL
      SELECT 40 deptno
           , 'OPERATIONS ' dname
           , 'BOSTON' loc
        FROM DUAL)
SELECT *
  FROM dept;

GET emp
WITH emp AS
     (SELECT 7369 empno
           , 'SMITH' ename
           , 'CLERK' job
           , 7902 mgr
           , '17-Dec-80' hiredate
           , 800 sal
           , NULL comm
           , 20 deptno
        FROM DUAL
      UNION ALL
      SELECT 7499 empno
           , 'ALLEN' ename
           , 'SALESMAN' job
           , 7698 mgr
           , '20-Feb-81' hiredate
           , 1600 sal
           , 300 comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7521 empno
           , 'WARD' ename
           , 'SALESMAN' job
           , 7698 mgr
           , '22-Feb-81' hiredate
           , 1250 sal
           , 500 comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7566 empno
           , 'JONES' ename
           , 'MANAGER' job
           , 7839 mgr
           , '02-Apr-81' hiredate
           , 2975 sal
           , NULL comm
           , 20 deptno
        FROM DUAL
      UNION ALL
      SELECT 7654 empno
           , 'MARTIN' ename
           , 'SALESMAN' job
           , 7698 mgr
           , '28-Sep-81' hiredate
           , 1250 sal
           , 1400 comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7698 empno
           , 'BLAKE' ename
           , 'MANAGER' job
           , 7839 mgr
           , '01-May-81' hiredate
           , 2850 sal
           , NULL comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7782 empno
           , 'CLARK' ename
           , 'MANAGER' job
           , 7839 mgr
           , '09-Jun-81' hiredate
           , 2450 sal
           , NULL comm
           , 10 deptno
        FROM DUAL
      UNION ALL
      SELECT 7788 empno
           , 'SCOTT' ename
           , 'ANALYST' job
           , 7566 mgr
           , '19-Apr-87' hiredate
           , 3000 sal
           , NULL comm
           , 20 deptno
        FROM DUAL
      UNION ALL
      SELECT 7839 empno
           , 'KING' ename
           , 'PRESIDENT' job
           , NULL mgr
           , '17-Nov-81' hiredate
           , 5000 sal
           , NULL comm
           , 10 deptno
        FROM DUAL
      UNION ALL
      SELECT 7844 empno
           , 'TURNER' ename
           , 'SALESMAN' job
           , 7698 mgr
           , '08-Sep-81' hiredate
           , 1500 sal
           , NULL comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7876 empno
           , 'ADAMS' ename
           , 'CLERK' job
           , 7788 mgr
           , '23-May-87' hiredate
           , 1100 sal
           , NULL comm
           , 20 deptno
        FROM DUAL
      UNION ALL
      SELECT 7900 empno
           , 'JAMES' ename
           , 'CLERK' job
           , 7698 mgr
           , '03-Dec-81' hiredate
           , 950 sal
           , NULL comm
           , 30 deptno
        FROM DUAL
      UNION ALL
      SELECT 7902 empno
           , 'FORD' ename
           , 'ANALYST' job
           , 7566 mgr
           , '03-Dec-81' hiredate
           , 3000 sal
           , NULL comm
           , 20 deptno
        FROM DUAL
      UNION ALL
      SELECT 7934 empno
           , 'MILLER' ename
           , 'CLERK' job
           , 7782 mgr
           , '23-Jan-82' hiredate
           , 1300 sal
           , NULL comm
           , 10 deptno
        FROM DUAL)
SELECT *
  FROM emp;