Hello Guys,

We need to convert SQL Server Query with new SQL92 left join syntax to
Oracle 8i.

create table t1(a int, b int, c int);
create table t2(a int, b int, c int);

insert into t1 values(1,1,1);
insert into t1 values(2,1,1);
insert into t1 values(3,1,1);
insert into t2 values(1,1,1);
insert into t2 values(2,2,1);

Here is the query,

select * from t1 left join t2 on t1.a=t2.a and t1.b>=t2.b

Of cource we should use the (+) syntax. Anybody knows how to do it?Thank you
in advance,

Daning



Oracle LazyDBA home page