SELECT TABLEA.A,TABLEA.B,TABLEA.C,TABLEB.A,TABLEB.B,TABLEB,D FROM TABLEA,TABLEB WHERE TABLEA.A=TABLEB.A AND TABLEA.B=TABLEB.B
select distinct a.A , a.B , a.C ,b.D from table a,table b where a.A=b.A
SELECT TABLEA.A,TABLEA.B,TABLEA.C,TABLEB,D FROM TABLEA,TABLEB WHERE TABLEA.A=TABLEB.A ;
baojianjun(包子) 4屉 leborety(那只螃蟹) 4只 yanzi_2004(不换) 2个 liuyi8903(西西) 4条 hero1981(英雄) 就是个包子select a.a,a.b,a.c,b.d from a,b where a.a=b.a(+) union select b.a,b.b,a.c,b.d from a,b where b.a=a.a(+)
select A.A,A.B,A.C,B.D from A,B where A.A=B.A(+) union select B.A,B.B,B.C,B.D from A,B where B.A=A.A(+)
select nvl(a.a,b.a) a, nvl(a.b,b.b), a.c, b.d from a full join b on a.a = b.a and a.b = b.b(汗还好,我还不算包子,要不可真要出笑话了)
airway(潇渺) select nvl(a.a,b.a) a, nvl(a.b,b.b), a.c, b.d from a full join b on a.a = b.a and a.b = b.b有问题啊?
没有问题 select a.a,a.b,a.c,b.d from a,b where a.a=b.a(+) union select b.a,b.b,a.c,b.d from a,b where b.a=a.a(+) 这个才有问题,b字段数据一样掩饰了错误不过 select nvl(a.a,b.a) a, nvl(a.b,b.b), a.c, b.d from a full join b on a.a = b.a and a.b = b.b是对的 还应该把 nvl(a.b,b.b)改成nvl(a.b,b.b) b 呵呵
select t1.a,t1.b,t2.c,t3.d from (select a,b from A union select a,b from B) t1,A t2,B t3 where t1.a=t2.a(+) and t1.b=t2.b(+) and t1.a=t3.a(+) and t1.b=t3.b(+);
刚才测试,上面的sql没问题。
select nvl(aa.a,bb.a) as A,nvl(aa.b,bb.b) as B,aa.c,bb.d from aa full join bb on aa.a=bb.a /* A B C D QQ VVV SSS SDFD EE RRR SDF SER DD WWW DDD FF EEE DFE TT WWW DTYD CC EER DERE */
FROM A,B
WHERE A.A=B.A(+)
select distinct a.A , a.B , a.C ,b.D
from table a,table b
where a.A=b.A
leborety(那只螃蟹) 4只
yanzi_2004(不换) 2个
liuyi8903(西西) 4条
hero1981(英雄) 就是个包子select a.a,a.b,a.c,b.d from a,b where a.a=b.a(+)
union
select b.a,b.b,a.c,b.d from a,b where b.a=a.a(+)
select B.A,B.B,B.C,B.D from A,B where B.A=A.A(+)
from a full join b on a.a = b.a and a.b = b.b(汗还好,我还不算包子,要不可真要出笑话了)
select nvl(a.a,b.a) a, nvl(a.b,b.b), a.c, b.d
from a full join b on a.a = b.a and a.b = b.b有问题啊?
select a.a,a.b,a.c,b.d from a,b where a.a=b.a(+)
union
select b.a,b.b,a.c,b.d from a,b where b.a=a.a(+)
这个才有问题,b字段数据一样掩饰了错误不过
select nvl(a.a,b.a) a, nvl(a.b,b.b), a.c, b.d
from a full join b on a.a = b.a and a.b = b.b是对的
还应该把
nvl(a.b,b.b)改成nvl(a.b,b.b) b
呵呵
你们的代码还是有问题,我建了个表试了下,不行!
from B) t1,A t2,B t3 where t1.a=t2.a(+) and t1.b=t2.b(+) and t1.a=t3.a(+)
and t1.b=t3.b(+);
/*
A B C D
QQ VVV SSS SDFD
EE RRR SDF SER
DD WWW DDD
FF EEE DFE
TT WWW DTYD
CC EER DERE
*/