急，在线给分

[loskill]

我有两张表
t1:字段1 t2:字段1
1 1
2 2
3 4
我要生成t3：字段1 字段2
1 1
2 2
3 null
null 4
怎么写啊

[csuxiong]

create table t3 as select t1.子段1，t2.字段2 from t1,t2(+)

[csuxiong]

或者：
create table t3 as select t1.子段1，t2.字段2 from t1，t2 where t1.字段1（+）=t2.字段1（+）；
试试看看

[jiezhi]

如果是查詢：
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 (+)

[armu80830]

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
)

[shuipipi]

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

即可！

[Wnyu]

Create table t3 as
(select t1.字段1 字段1, t2.字段1 字段2 from t1,t2 where t1.字段1 =t2.字段1 (+));

[l2g32003]

select t1.字段1 , t2.字段1 from t1 full outer join t2 on t1.字段1=t2.字段1;