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 по дате отправления: