Введение в модель данных SQL

FROM EMP AS EMP1, EMP


SELECT EMP1.EMP_NO, EMP1.EMP_NAME,
EMP1.DEPT_NO, EMP2.EMP_NAME
FROM EMP AS EMP1, EMP AS EMP2, DEPT
WHERE EMP1.EMP_SAL < 15000.00 AND
EMP1.DEPT_NO = DEPT.DEPT_NO AND
DEPT.DEPT_MNG = EMP2.EMP_NO;

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