Re: Complex Query - Data from 3 tables simultaneously - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Complex Query - Data from 3 tables simultaneously
Date
Msg-id 43609B27.6060303@archonet.com
Whole thread Raw
In response to Complex Query - Data from 3 tables simultaneously  (<Amit_Wadhwa@Dell.com>)
List pgsql-sql
Amit_Wadhwa@Dell.com wrote:
>  
> Basically I want a raw dump of data
> - Should have all the shipments regardless of whether they have any
> material items entered or not
> - Should have all Material Items for Every Shipment regardless of
> whether it was issued or not.
>  
> I know I need an outer join (Do I Not?), but am confused as to how to
> implement it.
> Because this seems to be a requirement of a reversed outer join (??)

SELECT s.*, m.*, i.*
FROM  shipments s
LEFT JOIN  materials m
ON s.www = m.xxx
LEFT JOIN  issued i
ON m.yyy = i.zzz
WHERE s.whatever = something

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: handling money type
Next
From: Andrew Sullivan
Date:
Subject: Re: why vacuum