关于两个表的SQL语句！

[jnzsk]

我有两个表：表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

[liangCK]

SELECT kdate FROM tb1 
UNION ALL
SELECT jkdate FROM tb2
ORDER BY 1

[百年树人]

select kdate from A
union
select jkdate from B

[sdhdy]

select kdate from 
(select kdate from a
union all
select jkdate from b) c
order by kdate

[victorcai2006]

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

[jnzsk]

记录不能重复！

[SQL77]

[Quote=引用 5 楼 jnzsk 的回复:]
记录不能重复！
[/Quote]

SELECT  DISTINCT kdate as tmpdate FROM tb1 
UNION ALL
SELECT DISTINCT jkdate as tmpdate FROM tb2
ORDER BY tmpdate

[dongweidv83]

select kdate as date from A
union
select jkdate as date from B
order by date

[liangCK]

[Quote=引用 5 楼 jnzsk 的回复:]
记录不能重复！
[/Quote]

SELECT kdate FROM tb1 
UNION
SELECT jkdate FROM tb2

[wangxinli_nissan]

select distinct kdate from A
union
select distinct jkdate from B

[guye1986]

select kdate from A 
union select jkdate from B
order by kdate

[dongweidv83]

select distinct a.date from
(
select kdate as date from A
union
select jkdate as date from B
)
order by a.date

[dongweidv83]

[Quote=引用 11 楼 dongweidv83 的回复:]
select distinct a.date from
(
select kdate as date from A
union
select jkdate as date from B
)
order by a.date
[/Quote]

忘了点东西 应该是：
select distinct a.date from
(
select kdate as date from A
union
select jkdate as date from B
) a
order by a.date

[tengjian1981]

select kdate from
(select kdate from a
union
select jkdate from b) c
order by kdate

[百年树人]

[Quote=引用 5 楼 jnzsk 的回复:]
记录不能重复！
[/Quote]
或者

select
  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]

[zhangle861010]

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

[-无-为-]

支持..........

[Quote=引用 15 楼 zhangle861010 的回复:]
SQL code
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
[/Quote]

[IamstudyingJava]

一个笛卡尔积

[zhouyemoye]

SELECT kdate FROM tb1
UNION ALL
SELECT jkdate FROM tb2
ORDER BY 1