Left outer join question

Поиск
Список
Период
Сортировка
От Bill Reynolds
Тема Left outer join question
Дата
Msg-id 7C0800F63CCF4149AC0FC5EE2A041226053A19FC@sr002-2k3exc.ateb.com
обсуждение исходный текст
Ответ на Efficiency of inner joins across multiple tables  (Saptarshi Guha <saptarshi.guha@gmail.com>)
Ответы Re: Left outer join question
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Saptarshi Guha
Дата:
Сообщение: Efficiency of inner joins across multiple tables
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Left outer join question