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 Forseth||Date: 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 Tuomi||Date: 2001-03-18 11:43:06|
|Subject: Join required??|