Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group