From: | Yuva Chandolu <ychandolu(at)ebates(dot)com> |
---|---|
To: | "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | outer join help... |
Date: | 2002-07-29 20:07:43 |
Message-ID: | A0F24737FCB34F489EC955D143BDD8510173E0E7@exchange-sf1.corp.ebates.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2002-07-29 20:07:55 | Re: question on backends |
Previous Message | Hannu Krosing | 2002-07-29 19:40:35 | Re: question on backends |