Postgres Pro
Downloads
Home   >   mailing lists

Left outer join question - Mailing list pgsql-general

From Bill Reynolds
Subject Left outer join question
Date
Msg-id 7C0800F63CCF4149AC0FC5EE2A041226053A19FC@sr002-2k3exc.ateb.com
Whole thread Raw
In response to Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
Responses Re: Left outer join question  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
Hey folks, stuck on something here and maybe I went down a dead end
road.
   Is it possible to have a left outer join on 2 tables from the same
originating table where T1 left outer joins to T2 and T1 left outer
joins to T3?   I guess I'm stuck on the FROM clause syntax or trying to
do something you just can't do.

   Maybe it is possible to join T1 and T1again, back to each other but I
didn't want to do that.

   Many Thanks, Bill

pgsql-general by date:

Previous
From: Saptarshi Guha
Date:
Subject: Efficiency of inner joins across multiple tables
Next
From: Raymond O'Donnell
Date:
Subject: Re: Left outer join question