drop table table1;
drop table table2;
create table table1
(
id integer,
classid integer,
classid1 integer
);
insert into table1 values (1,11,111);
insert into table1 values (1,null,222);
insert into table1 values (1,33,null);
insert into table1 values (1,44,444);
commit;
create table table2
(
classid integer,
classname varchar2(10)
);
insert into table2 values (11,'name11');
insert into table2 values (22,'name22');
insert into table2 values (33,'name33');
insert into table2 values (111,'name111');
commit;
select a.id,b.classname,c.classname
from table1 a,table2 b,table2 c
where a.classid=b.classid(+) and a.classid1=c.classid(+); |