JOIN of a table with many detail tables

From: DaVinci <bombadil(at)wanadoo(dot)es>
To: Lista PostgreSql <pgsql-general(at)postgresql(dot)org>
Subject: JOIN of a table with many detail tables
Date: 2001-03-01 15:46:04
Message-ID: 20010301164604.A18779@fangorn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-01 15:59:43 Re: Thought on OIDs
Previous Message Denis Perchine 2001-03-01 15:40:45 Re: Postgres eats up memory when using cursors