Multiple outer join on same table

Поиск
Список
Период
Сортировка
От Marco Lazzeri
Тема Multiple outer join on same table
Дата
Msg-id 1076350332.31616.45.camel@macbeth.intranet.noze.it
обсуждение исходный текст
Ответы Re: Multiple outer join on same table
Re: Multiple outer join on same table
Список pgsql-sql
Hi!
I'm searching a better (quicker) way to retrieve data as I used to do
using the following query...

==
SELECT   main.codice,   other.value AS value_one,   other.value AS value_two
FROM main LEFT OUTER JOIN other                        ON main.id =
other.id_main                     LEFT OUTER JOIN other AS other2 ON main.id =
other2.id_main
WHERE       other.type = 'type_one'
AND other2.type = 'type_two';
==

Thanks,
Marco




В списке pgsql-sql по дате отправления: