Example: Searching for Atlanta Employees - Teradata VantageCloud Lake

The following statement searches for the names of all employees who work in Atlanta.

SELECT Name 
FROM Employee 
WHERE DeptNo IN
 (SELECT DeptNo 
  FROM Department 
  WHERE Loc = 'ATL');