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; |
| Пример 15.17.1. |
| Закрыть окно |
Введение в модель данных SQL