Join Condition (SQL)

We can retrieve the name and address of all employees who work for the ‘Research’ department by specifying a join condition:

SELECT FNAME, LNAME, ADDRESS
FROM   EMPLOYEE, DEPARTMENT
WHERE  DNAME = 'Research' AND DNUMBER = DNO

We can specify as many join conditions as we want.

We can also use an explicit JOIN clause:

SELECT location, mgrssn
FROM   DEPARTMENT
JOIN   DEPT_LOCATIONS
ON     DEPARTMENT.number=DEPT_LOCATIONS.number
WHERE  DNAME = 'Research';