我有两个表:表A和表B,表A中有,kdate,rzje,表B中有,jkdate,jkje,
A: rzje kdate
100.00 2009-05-12
200.00 2009-05-15
B: jkje jkdate
100.00 2009-05-11
50.00 2009-05-16查询后结果2009-05-11
2009-05-12
2009-05-15
2009-05-16
A: rzje kdate
100.00 2009-05-12
200.00 2009-05-15
B: jkje jkdate
100.00 2009-05-11
50.00 2009-05-16查询后结果2009-05-11
2009-05-12
2009-05-15
2009-05-16
UNION ALL
SELECT jkdate FROM tb2
ORDER BY 1
union
select jkdate from B
(select kdate from a
union all
select jkdate from b) c
order by kdate
SELECT kdate FROM tb1
UNION ALL
SELECT jkdate FROM tb2
ORDER BY 1
或者这么写也应该可以SELECT kdate as tmpdate FROM tb1
UNION ALL
SELECT jkdate as tmpdate FROM tb2
ORDER BY tmpdate
SELECT DISTINCT kdate as tmpdate FROM tb1
UNION ALL
SELECT DISTINCT jkdate as tmpdate FROM tb2
ORDER BY tmpdate
union
select jkdate as date from B
order by date
SELECT kdate FROM tb1
UNION
SELECT jkdate FROM tb2
union
select distinct jkdate from B
select kdate from A
union select jkdate from B
order by kdate
(
select kdate as date from A
union
select jkdate as date from B
)
order by a.date
忘了点东西 应该是:
select distinct a.date from
(
select kdate as date from A
union
select jkdate as date from B
) a
order by a.date
(select kdate from a
union
select jkdate from b) c
order by kdate
distinct
[date]
from
(
select convert(varchar(10),kdate,120) as [date] from A
union all
select convert(varchar(10),jkdate,120) from B
) t
order by
[date]
declare @t1 table(rzje money,kdate datetime)
insert @t1
select 100.00,'2009-05-12' union all
select 200.00,'2009-05-15'
declare @t2 table(jkje money,jkdate datetime)
insert @t2
select 100.00,'2009-05-11' union all
select 50.00,'2009-05-12'select * from
(
select kdate from @t1
union
select jkdate from @t2
) a order by kdate
UNION ALL
SELECT jkdate FROM tb2
ORDER BY 1