SQL Statements › SELECT › Subselect › Example 3

Example 3

Show all rows of the employee-to-project-activity table TEMPRAC for Department E11, as determined by the employee table TEMPL.

      SELECT *
      FROM CA.TEMPRAC
      WHERE EMPNO IN (SELECT EMPNO
                      FROM CA.TEMPL
                      WHERE WORKDEPT = 'E11')