表A的数据结构:中文名称 字段名 类型 长度
学号 code N 4
日期 riqi D 8
分数 fsh N 4
-------------------------
表A的数据结构:中文名称 字段名 类型 长度
学号 code N 4
日期 riqi D 8
分数 fsh N 4
----------------------------- 表A的数据为:
(1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) 表B的数据为: (1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) (1102,2011-11-13 12:00:10,80),(1103,2011-11-10 12:00:10,20)我想要以下的查询结果,相同记录的不显示
中文名称 字段名 类型 长度
----------------------------------------
code riqi fsh
-----------------------------------------
1101 2011-11-10 12:00:10 100
1102 2011-11-10 12:00:10 10
1102 2011-11-13 12:00:10 80
1103 2011-11-10 12:00:10 20
学号 code N 4
日期 riqi D 8
分数 fsh N 4
-------------------------
表A的数据结构:中文名称 字段名 类型 长度
学号 code N 4
日期 riqi D 8
分数 fsh N 4
----------------------------- 表A的数据为:
(1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) 表B的数据为: (1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) (1102,2011-11-13 12:00:10,80),(1103,2011-11-10 12:00:10,20)我想要以下的查询结果,相同记录的不显示
中文名称 字段名 类型 长度
----------------------------------------
code riqi fsh
-----------------------------------------
1101 2011-11-10 12:00:10 100
1102 2011-11-10 12:00:10 10
1102 2011-11-13 12:00:10 80
1103 2011-11-10 12:00:10 20
(1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) 表B的数据为: (1101,2011-11-10 12:00:10,100),(1102,2011-11-10 12:00:10,10) (1102,2011-11-10 12:00:10,80),(1103,2011-11-10 12:00:10,20)我想要以下的查询结果,相同记录的不显示
中文名称 字段名 类型 长度
----------------------------------------
code riqi fsh
-----------------------------------------
1101 2011-11-10 12:00:10 100
1102 2011-11-10 12:00:10 10
1102 2011-11-10 12:00:10 80
1103 2011-11-10 12:00:10 20
--------------------------------------
不好意思,用上面的数据
select code, riqi, fsh from 表A
union
select code, riqi, fsh from 表B
(select 1101,'2011-11-10 12:00:10',100 from dual union ALL
select 1102,'2011-11-10 12:00:10',10 from dual
),b as (select 1101,'2011-11-10 12:00:10',100 from dual union ALL
select 1102,'2011-11-10 12:00:10',10 from dual union ALL
select 1102,'2011-11-13 12:00:10',80 from dual union ALL
select 1103,'2011-11-10 12:00:10',20 from dual
)select * from a union select * from b
union
select code, riqi, fsh from 表B
from (select ta.code, ta.riqi, ta.fsh
from A ta
union all
select tb.code, tb.riqi, tb.fsh from B tb) b
select code, riqi, fsh from 表A
union all
select code, riqi, fsh from 表B