FROM EMP, DEPT,
SELECT DISTINCT DEPT.DEPT_NO
FROM EMP, DEPT, PRO
WHERE EMP.EMP_NO = PRO.PRO_MNG
AND EMP.DEPT_NO = DEPT.DEPT_NO
AND PRO.PRO_TITLE LIKE DEPT.DEPT_NAME || '%';
Введение в модель данных SQL
SELECT DISTINCT DEPT.DEPT_NO
FROM EMP, DEPT, PRO
WHERE EMP.EMP_NO = PRO.PRO_MNG
AND EMP.DEPT_NO = DEPT.DEPT_NO
AND PRO.PRO_TITLE LIKE DEPT.DEPT_NAME || '%';
