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.

 

Parent topic:

Inner join