WHERE EMP_NO

SELECT EMP.EMP_NO, EMP.EMP_NAME, EMP.DEPT_NO,
(SELECT EMP_NAME
FROM EMP
WHERE EMP_NO = DEPT_MNG)
FROM EMP, DEPT
WHERE EMP.EMP_SAL < 15000.00 AND
EMP.DEPT_NO = DEPT.DEPT_NO;

Содержание  Назад  Вперед

---