From: jeff sacksteder <jsacksteder@gmail.com>
To: pgsql-sql@postgresql.org
Subject: how to do 'deep queries'?
Date: Mon, 26 Sep 2005 20:34:14 -0400
Message-ID: <51c8a7be050926173448a22f8@mail.gmail.com> (raw)
Is there supported syntax to do 'deep' queries? That is where A relates to B
relates to C, returning fields from each table?
This doesn't seem to work. Is there a google-able term for this sort of
query?
select
foo.aaa,
bar.bbb,
baz.ccc
from
foo,bar,baz
where
foo.bar_id = bar.id <http://bar.id;
and
bar.baz_id = baz.id <http://baz.id;
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: jsacksteder@gmail.com
Subject: Re: how to do 'deep queries'?
In-Reply-To: <51c8a7be050926173448a22f8@mail.gmail.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