SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 42

where there is an exact match between the columns used in the
WHERE clause.
Figure 2-9: Joining two or more tables. There are two very important
joins: Equijoin and Outer-join.
Example:
SELECT ename, job, dept.deptno, dname
FROM emp, dept
WHERE emp.deptno = dept.deptno;
Or if you want to further reduce the number of records in the
output you can extend the filter in the WHERE clause just like
the example mentioned below. In the WHERE clause there are
two conditions on both sides of AND operator, only those
records will be displayed that satisfy both of these conditions.