Re: Help getting around Outer Join limitation

From: mark tomlinson <marktoml_at_gdi.net>
Date: 1998/02/03
Message-ID: <34d94d0d.330130242@newshost.us.oracle.com>#1/1

And here is one that does 3 tables...

--SQL to create tables and populate

create table table_one (one_id integer, one_desc char(20));
create table table_two (two_id integer, two_desc char(20));
create table table_three (three_id integer, three_desc char(20));
insert into table_one (one_id, one_desc) values(1, 'test1-1')
insert into table_one (one_id, one_desc) values(2, 'test1-2')
insert into table_one (one_id, one_desc) values(3, 'test1-3')
insert into table_two (two_id, two_desc) values(1, 'test2-1')
insert into table_two (two_id, two_desc) values(3, 'test2-3')
insert into table_two (two_id, two_desc) values(4, 'test2-4')
insert into table_three(three_id, three_desc) values(1, 'test3-1')

insert into table_three(three_id, three_desc) values(2, 'test3-2') insert into table_three(three_id, three_desc) values(5, 'test3-5')

--the select statement, (can be done in ODBCTEST)

select one_id, one_desc, two_id, two_desc, three_id, three_desc from
{oj table_one left outer join table_two on one_id=two_id},
{oj table_one left outer join table_three on one_id=three_id}
Received on Tue Feb 03 1998 - 00:00:00 CST