SELECT  table1.column, table2.column
FROM    table1
[ JOIN table2 USING (column_name) ] |
[ JOIN table2 
    ON (table1.column_name = table2.column_name) ];

SQL> SELECT   e.ename, e.job, d.loc
  2    FROM   EMP e, DEPT d
  3   WHERE   e.deptno = d.deptno
  4     AND   e.deptno = 10;

ENAME      JOB       LOC
---------- --------- -------------
CLARK      MANAGER   NEW YORK
KING       PRESIDENT NEW YORK
MILLER     CLERK     NEW YORK

SQL> SELECT   e.ename, e.job, d.loc
  2    FROM   EMP e INNER JOIN DEPT d
  3                   ON (e.deptno = d.deptno)
  4   WHERE   e.deptno = 10;

ENAME      JOB       LOC
---------- --------- -------------
CLARK      MANAGER   NEW YORK
KING       PRESIDENT NEW YORK
MILLER     CLERK     NEW YORK

SQL> SELECT   e.ename, e.job, d.loc
  2    FROM   EMP e JOIN DEPT d USING (deptno)
  3   WHERE   deptno = 10;

ENAME      JOB       LOC
---------- --------- -------------
CLARK      MANAGER   NEW YORK
KING       PRESIDENT NEW YORK
MILLER     CLERK     NEW YORK

SQL>