outer join help...

Поиск
Список
Период
Сортировка
От Yuva Chandolu
Тема outer join help...
Дата
Msg-id A0F24737FCB34F489EC955D143BDD8510173E0E7@exchange-sf1.corp.ebates.com
обсуждение исходный текст
Список pgsql-hackers
Hi,

I need small help in outer joins in postgresql. We have three tables created
using the following scripts

CREATE TABLE "yuva_test1" ( "yt1_id" numeric(16, 0),  "yt1_name" varchar(16) NOT NULL,  "yt1_descr" varchar(32)
);

CREATE TABLE "yuva_test2" ( "yt2_id" numeric(16, 0),  "yt2_name" varchar(16) NOT NULL,  "yt2_descr" varchar(32)
);

CREATE TABLE "yuva_test3" ( "yt3_id" numeric(16, 0),  "yt3_name" varchar(16) NOT NULL,  "yt3_descr" varchar(32)
);

When I run the query "select yt1_name, yt1_descr, yt2_name, yt2_descr,
yt3_name, yt3_descr from yuva_test1, yuva_test2, yuva_test3 where yt1_id =
yt2_id(+) and yt1_id = yt3_id(+)", it works fine with Oracle(created same
tables and data on Oracle database) and gives the results as expected.

But I don't know what is the equivalent query in postgres... Can some one
help me.

Thanks
Yuva


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Postgres Lock Up Fun
Следующее
От: nconway@klamath.dyndns.org (Neil Conway)
Дата:
Сообщение: (still) unintegrated stuff in CVS