Subquery Examples | SQL SELECT Statements | Teradata Vantage - Example: Simple Subquery Using the IN Logical Predicate - Advanced SQL Engine - Teradata Database

This example selects the names and department locations of those employees who report to manager Aguilar (whose employee number is 10007).

     SELECT name, loc      FROM employee, department      WHERE employee.dept_no = department.dept_no      AND   employee.dept_no IN (SELECT dept_no                                 FROM department                                 WHERE mgr_no = 10007);