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
