Postgres Pro
Downloads
Home   >   mailing lists

Re: left outer join on 3 tables ? - Mailing list pgsql-general

From Michael Nolan
Subject Re: left outer join on 3 tables ?
Date
Msg-id 4abad0eb0809151952rdf9f366u65ba72f7e0b7b65d@mail.gmail.com
Whole thread Raw
In response to left outer join on 3 tables ?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view
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



pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: left outer join on 3 tables ?
Next
From: "Chris Velevitch"
Date:
Subject: Default procedural language