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

Figure 2-10: Equijoin/Simple Join/Inner Join. The equality sign is used
to join two tables.
Example:
SELECT ename, job, dept.deptno, dname
FROM emp, dept
WHERE emp.deptno = dept.deptno
AND job = 'CLERK';
Output:
ENAME JOB DEPTNO DNAME
---------- --------- ---------- --------------
MILLER CLERK 10 ACCOUNTING
SMITH CLERK 20 RESEARCH
ADAMS CLERK 20 RESEARCH
JAMES CLERK 30 SALES