how to do 'deep queries'? - Mailing list pgsql-sql

From jeff sacksteder
Subject how to do 'deep queries'?
Date
Msg-id 51c8a7be050926173448a22f8@mail.gmail.com
Whole thread Raw
List pgsql-sql
Is there supported syntax to do 'deep' queries? That is where A relates to B relates to C, returning fields from each
table?<br/><br /> This doesn't seem to work. Is there a google-able term for this sort of query?<br /><br /> select <br
/>   foo.aaa,<br />    bar.bbb,<br />    baz.ccc<br /><br /> from<br />    foo,bar,baz<br /><br /> where <br />   
foo.bar_id= <a href="http://bar.id">bar.id</a><br /> and<br />    bar.baz_id = <a href="http://baz.id">baz.id</a><br
/><br/><br /><br /> 

pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: add column if doesn't exist
Next
From: Ferindo Middleton Jr
Date:
Subject: Why doesn't the SERIAL data type automatically have a UNIQUE CONSTRAINT