From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Nicolas Fertig <nfertig@swissnow.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: OUTER JOIN with filter
Date: Sat, 1 Mar 2003 17:07:09 -0800 (PST)
Message-ID: <20030301170535.U21117-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <3e61011d$0$1220$5402220f@news.sunrise.ch>
On Sat, 1 Mar 2003, Nicolas Fertig wrote:
> Can anyone help me with the problem bellow ?
>
> SELECT TM.some_field, TS.name
> FROM table_main TM
> LEFT OUTER JOIN (SELECT name FROM table_slave WHERE c1 = 'myvalue') TS
> USING(id)
Maybe,
select tm.some_field, ts.name
from table_tmain tm left outer join table_slave ts
on (tm.id=ts.id and ts.c1='myvalue');
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: sszabo@megazone23.bigpanda.com, nfertig@swissnow.ch
Subject: Re: OUTER JOIN with filter
In-Reply-To: <20030301170535.U21117-100000@megazone23.bigpanda.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