Postgres Pro
Downloads
Home   >   mailing lists

JOIN of a table with many detail tables - Mailing list pgsql-general

From DaVinci
Subject JOIN of a table with many detail tables
Date
Msg-id 20010301164604.A18779@fangorn.net
Whole thread Raw
List pgsql-general
Tree view 
 Hi all.

 I want to make a LEFT JOIN of table A with detail tables B and C. How can I
 make that?:

     SELECT A.*, B.*, C.* FROM A LEFT JOIN B ON A.foo = B.bar ???????

 I don't know where to put info of JOIN between A and C.

 Any help, please? Thanks.

                                                         David

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres eats up memory when using cursors
Next
From: Bruce Momjian
Date:
Subject: Re: Addison-Wesley looking for authors