全部博文
-
编辑 删除
低版本数据库中替代全连接功能的语句
创建表：create table t1( aa number(4) not null,bb number(4));create table t2( aa number(4) not null,cc number(4));填入数据：insert into t1 values(1,10); insert into t1 values(2,20); insert into t1 values(3,30); insert into t1 values(3,30); insert into t2 values(2,200); insert into t2 values(3,300); insert into t2 values(4,400); insert into t2 values(4,400); 需要得到结果： AA BB CC---------- ---------- ---------- 1 10 2 20 200 3
