或者: create table t3 as select t1.子段1,t2.字段2 from t1,t2 where t1.字段1(+)=t2.字段1(+); 试试看看
如果是查詢: select t1.字段1,t2.字段1 from t1,t2 where t1.字段1 =t2.字段1 (+) 如果是建立表: create table t3 as select t1.字段1,t2.字段1 from t1,t2 where t1.字段1 =t2.字段1 (+)
select t1.字段1 , t2.字段1 from t1 full outer join t2 on t1.字段1=t2.字段1;
select distict tc1,tc2 from ( select t1.字段1 as tc1,t2.字段1 as tc2 from t1,t2 where t1.字段1 =t2.字段1(+) union select t1.字段1 as tc1,t2.字段1 as tc2 from t1,t2 where t1.字段1(+)=t2.字段1 )
select t1.字段1, t2.字段1 from t1,t2 where t1.字段1 = t2.字段1(+) union all select t1.字段1, t2.字段1 from t1,t2 where t1.字段1(+) = t2.字段1即可!
Create table t3 as (select t1.字段1 字段1, t2.字段1 字段2 from t1,t2 where t1.字段1 =t2.字段1 (+));
create table t3 as select t1.子段1,t2.字段2 from t1,t2 where t1.字段1(+)=t2.字段1(+);
试试看看
select t1.字段1,t2.字段1 from t1,t2 where t1.字段1 =t2.字段1 (+)
如果是建立表:
create table t3 as
select t1.字段1,t2.字段1 from t1,t2 where t1.字段1 =t2.字段1 (+)
(
select t1.字段1 as tc1,t2.字段1 as tc2 from t1,t2 where t1.字段1 =t2.字段1(+)
union
select t1.字段1 as tc1,t2.字段1 as tc2 from t1,t2 where t1.字段1(+)=t2.字段1
)
union all
select t1.字段1, t2.字段1 from t1,t2 where t1.字段1(+) = t2.字段1即可!
(select t1.字段1 字段1, t2.字段1 字段2 from t1,t2 where t1.字段1 =t2.字段1 (+));