关于union取并集,解决问题立即给分,多谢

[lci21]

有两个表t1和t2
t1:
字段1 字段2 字段3
006 ... ...
002 ... ...
003 ... ...
....
t2:
字段1 字段2 字段3
006 ... ...
008 ... ...
003 ... ...
...
期望取出数据两个表地并集数据
006 ... ...
002 ... ...
003 ... ...
008 ... ...
也即是,t1,t2对应的字段1,如果t1中有数据,则不再取t2的数据
(取出所有t1的数据和t2的数据,要求t2的字段1对应的数据在t1中不存在)
谢谢

[swordmanli]

select *
from t1

union

select t1.*
from t1 right outer join t2 on (t1.字段1 = t2.字段1)
where t1.字段1 is null

[lci21]

谢谢,但是结果不对啊,并没有取到我期望的结果

[lci21]

另外要求不能用not in关键字

[新的飞扬]

select t1.* from t1
union
select t2.* from t2 join t1 on t2.1<>t1.1

[yaojiesheng]

select * from t1
union
select * from t2 where t1.字段1<>t2.字段1

[lci21]

感谢楼上两位,但是结果不对,
包含 UNION 运算符的 SQL 语句中的所有查询都必须在目标列表中具有相同数目的表达式。

[CrazyFor]

呵呵~~~
select * from T1
union
select t2.* from t2 left outer join t1 on t2.col1=t1.col1
where t1.col1 is null

[yelook]

哈哈~~~
select col1,col2,col3 from T1
union all
select t2.col1,t2.col2,t2.col3 from t2 left outer join t1 on t2.col1=t1.col1
where t1.col1 is null