Hello all,

when I try to execute the following query against the employee.fdb
database

SELECT DEPARTMENT1.DEPARTMENT, DEPARTMENT1.LOCATION
FROM DEPARTMENT DEPARTMENT
INNER JOIN DEPARTMENT DEPARTMENT1 ON DEPARTMENT.DEPT_NO =
DEPARTMENT1.HEAD_DEPT
WHERE DEPARTMENT.MNGR_NO = 105

I get no result, while if I run the following query

SELECT DEPARTMENT1.DEPARTMENT, DEPARTMENT1.LOCATION
FROM DEPARTMENT A
INNER JOIN DEPARTMENT DEPARTMENT1 ON A.DEPT_NO = DEPARTMENT1.HEAD_DEPT
WHERE A.MNGR_NO = 105

I get the following expected result

DEPARTMENT LOCATION
Sales and Marketing San Francisco
Engineering Monterey
Finance Monterey

Where is the mistake?

Thanks

Jack