Description for the Expression

This image shows the expression.

SELECT DISTINCT 10 DEPTNO, 10 DEPTNAME, 10 LOC FROM DEPARTMENT_TAB 10 EMPLOYEE_TAB 11 WHERE 9910 DEPTNO = #deptno) AND (11 DEPTNO =10 DEPTNO))