EMP AS EMP1 INNER JOIN
SELECT EMP1.EMP_NO, EMP2.EMP_NAME
FROM ( EMP AS EMP1 INNER JOIN DEPT
ON EMP1.DEPT_NO = DEPT.DEPT_NO AND
EMP1.EMP_SAL > 30000.00)
INNER JOIN EMP AS EMP2 ON DEPT.MNG = EMP2.EMP_NO;
Введение в модель данных SQL
SELECT EMP1.EMP_NO, EMP2.EMP_NAME
FROM ( EMP AS EMP1 INNER JOIN DEPT
ON EMP1.DEPT_NO = DEPT.DEPT_NO AND
EMP1.EMP_SAL > 30000.00)
INNER JOIN EMP AS EMP2 ON DEPT.MNG = EMP2.EMP_NO;
