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