Re: left outer join on 3 tables ?

Try:

select e.name, w.rate, d.level

from employees e left join wage w on (e.job = w.job)
left join danger d on (d.job = e.job)

where d.level <= 2;

name rate level
---- ---- -----
sue -N- 1
alan 20 2