Код: Выделить всё
SELECT DEPARTMENT.DEPT_NO, DEPARTMENT.DEPARTMENT, PDN.PDN
FROM CSTMONTH
INNER JOIN (DEPARTMENT INNER JOIN PDN ON DEPARTMENT.DEPT_NO=PDN.FK_DEPT_NO)
ON CSTMONTH.MONTH_NO=PDN.FK_MONTH_NO
WHERE (((CSTMONTH.MONTH_NO)=1));
Код: Выделить всё
SELECT DEPARTMENT.DEPT_NO, DEPARTMENT.DEPARTMENT, PDN.PDN
FROM CSTMONTH С
INNER JOIN (DEPARTMENT INNER JOIN PDN ON DEPARTMENT.DEPT_NO=PDN.FK_DEPT_NO)
ON C.MONTH_NO=PDN.FK_MONTH_NO
WHERE (((C.MONTH_NO)=1));
ВОт так
Код: Выделить всё
***
FROM DEPARTMENT D, CSTMONTH С ***