From: frank church <pgsql@adontendev.net>
To: pgsql-sql@postgresql.org
Subject: Using subselects as joins in POstgeSQL (possible?, examples)
Date: Fri, 22 Jul 2005 12:13:17 +0000
Message-ID: <1122034397.42e0e2ddc3f4a@webmail.adontendev.net> (raw)
Is it possible to use subselects as joins in PostgreSQL.
eg.
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a (second subselect)
b where (in table criteria) and a.a = b.a
or
select a.a, a.b, a.c, b.a, b.b. b.c from (first subsselect) a join (second
subselect) b on a.a = b.a where (in table criteria)
I have a feeling it is possible but I need the right syntax
//Frank
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
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: pgsql@adontendev.net
Subject: Re: Using subselects as joins in POstgeSQL (possible?, examples)
In-Reply-To: <1122034397.42e0e2ddc3f4a@webmail.adontendev.net>
* 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