Inner join using the WHERE clause

To use the WHERE clause to perform the same join as you perform using the INNER JOIN syntax, enter both the join condition and the additional selection condition in the WHERE clause.

The tables to be joined are listed in the FROM clause, separated by commas.

  SELECT EMPNO, LASTNAME, PROJNO
    FROM CORPDATA.EMPLOYEE, CORPDATA.PROJECT
    WHERE EMPNO = RESPEMP
    AND LASTNAME > 'S'

This query returns the same output as the previous example.