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

Mon, 29 Jul 2002 13:07:43 -0700
Yuva Chandolu <ychandolu@ebates.com>
outer join help...