DEPT_NO FROM DEPT WHERE EXISTS
SELECT DEPT. DEPT_NO FROM DEPT WHERE EXISTS (SELECT * FROM EMP, DEPT WHERE EMP.DEPT_NO = DEPT.DEPT_NO AND PRO.PRO_MNG = EMP.EMP_NO); |
Пример 14.16.2. |
Закрыть окно |
SELECT DEPT. DEPT_NO FROM DEPT WHERE EXISTS (SELECT * FROM EMP, DEPT WHERE EMP.DEPT_NO = DEPT.DEPT_NO AND PRO.PRO_MNG = EMP.EMP_NO); |
Пример 14.16.2. |
Закрыть окно |