From: Josh Berkus <josh@agliodbs.com>
To: Ludek Finstrle <xfinstrl@informatics.muni.cz>
To: pgsql-sql@postgresql.org
Subject: Re: LEFT OUTER JOIN problem
Date: Thu, 27 Sep 2001 11:22:55 -0700
Message-ID: <web-126925@davinci.ethosmedia.com> (raw)
In-Reply-To: <20010921153200.M19935@anxur.fi.muni.cz>
Ludek,
> I have this problem (maybe only in my head ;o)):
Yup. Or it's a language problem. There's a fair Czech community of
PgSQL users, so hopefully you can get in touch with some of them. (Your
English is better than any of my 2nd languages -- it's just that
techincal docs are hard enough to understand in one's native language!)
> SELECT * FROM table1 LEFT OUTER JOIN table2 ON (table1.id =
> table2.table1_id)
> LEFT OUTER JOIN table3 ON (table2.id = table3.table2_id);
>
> This select return me only one row:
> 1,'blabla',1,1,'hello',NULL,NULL,NULL
>
> But I think it may return two rows:
> 1,'blabla',1,1,'hello',NULL,NULL,NULL
> 2,'arrrgh',NULL,NULL,NULL,NULL,NULL,NULL
Yes, it will. The query you want is:
SELECT * FROM table1 JOIN table2 ON (table1.id =
table2.table1_id)
LEFT OUTER JOIN table3 ON (table2.id = table3.table2_id);
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, xfinstrl@informatics.muni.cz
Subject: Re: LEFT OUTER JOIN problem
In-Reply-To: <web-126925@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox