Re: Join required?? - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Join required??
Date
Msg-id 20010318120133.6AE823EDA@plserver.of.de
Whole thread Raw
In response to Join required??  (Timo Tuomi <tt@sllpilots.fi>)
List pgsql-novice
On 18 Mar 2001 13:43:06 +0200, Timo Tuomi wrote:

> i.e. to sum the rows but if one of the rows doesn't exist on one of the tables
> then print just the existing row. How can I do this with postgresql-6.5.3?


Sounds to me like a GROUPed LEFT OUTER JOIN.
but you should give us more Information.

BTW: isn't postgresql-6.5.3 a bit too old? left outer join isn't
available before 7.1.



pgsql-novice by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Help with a query, please
Next
From: Louis Bertrand
Date:
Subject: Re: installing/running ODBC