outer join help...

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