The Un-Nested Query
SELECT Emp.Name
FROM Emp, Dept
WHERE
Emp.Age < 30
AND
Emp.Dept#=Dept.Dept#
AND
Dept.Loc = Seattle
AND
Emp.Emp#=Dept.Mgr