求一段多表联查的SQL语句
求一条SQL语句,有两个表：
[TableA]:
AID AName DateA
1 aaa1 2007-3-1
2 aaa2 2007-3-2
3 aaa3 2007-3-3
-------------------
[TableB]:
BID Bname DateB
12 www1 2007-3-1
13 www2 2007-3-2
14 www3 2007-3-2
==================
如何查询出这样的格式:
Date ID Name
2007-3-1 1 aaa1
2007-3-1 12 www1
2007-3-2 2 aaa2
2007-3-2 13 www2
2007-3-2 14 www3
2007-3-3 3 aaa3
===================
两个表唯一的对应关系就是日期DATE，请问如何写呢？
[解决办法]
select Date,ID,Name from
(
select * from TableA
union
select * from TableB
order by Date DESC
)as U
这样应该可以了吧
[解决办法]
select convert(char(10),DateA,126) as Date,AName as Name,AID as ID from A
union
select convert(char(10),DateB,126) as Date,BName as Name,BID as ID from B
order by Date
