Re: Join required??

From: Nabil Sayegh <evolution(at)sayegh(dot)de>
To: Timo Tuomi <tt(at)sllpilots(dot)fi>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Join required??
Date: 2001-03-18 12:10:00
Message-ID: 20010318120133.6AE823EDA@plserver.of.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lars Forseth 2001-03-18 13:18:13 Postgres - trouble starting the database on a suse 7.0 box - data dir not found
Previous Message Timo Tuomi 2001-03-18 11:43:06 Join required??