Ann W. Harrison wrote:


Whoops bad case of cut and paste!

The first of the variants that works should be like this!

select e.name
from employees e
left join departments d
on e.dept_id = d.dept_id and d.manager <> 'Voldemort'
where e.age > 20