关于联表查询？
大师们，我有三张表：
表1
aaa1bbb1ccc1ddd1
A1
B1
C1
D1
E1
表2
aaa2bbb2ccc2ddd2
A2
B2
C2
D2
E2
表3
aaa3bbb3ccc3ddd3
A3
B3
C3
D3
E3
要实现把aaa2、aaa3的数据追加到aaa1上，其它表的列数据则累加字段，如下：
aaa1bbb1ccc1ddd1bbb2ccc2ddd2bbb3ccc4ddd5
A1
B1
C1
D1
E1
A2
B2
C2
D2
E2
A3
B3
C3
D3
E3
如何用sql语句实现哦？
[解决办法]
SELECT aaaa1 ,
bbb1 ,
ccc1 ,
ddd1 ,
bbb2 ,
ccc2 ,
ddd2 ,
bbb3 ,
ccc3 ,
ddd3
FROM ( SELECT aaaa1 ,
bbb1 ,
ccc1 ,
ddd1 ,
NULL bbb2 ,
NULL ccc2 ,
NULL ddd2 ,
NULL bbb3 ,
NULL ccc3 ,
NULL ddd3
FROM 表1
UNION ALL
SELECT aaaa2 ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL
FROM 表2
UNION ALL
SELECT aaaa3 ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL ,
NULL
FROM 表3
) a
----------------------------
-- Author :TravyLee(物是人非事事休,欲语泪先流!)
-- Date :2012-11-22 10:56:13
-- Version:
-- Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--Jul 9 2008 14:43:34
--Copyright (c) 1988-2008 Microsoft Corporation
--Developer Edition on Windows NT 6.1 <X86> (Build 7601: Service Pack 1)
--
----------------------------
--> 测试数据：[表1]
if object_id('[表1]') is not null drop table [表1]
go
create table [表1]([aaa1] varchar(2),[bbb1] sql_variant,[ccc1] sql_variant,[ddd1] sql_variant)
insert [表1]
select 'A1',null,null,null union all
select 'B1',null,null,null union all
select 'C1',null,null,null union all
select 'D1',null,null,null union all
select 'E1',null,null,null
--> 测试数据：[表2]
if object_id('[表2]') is not null drop table [表2]
go
create table [表2]([aaa2] varchar(2),[bbb2] sql_variant,[ccc2] sql_variant,[ddd2] sql_variant)
insert [表2]
select 'A2',null,null,null union all
select 'B2',null,null,null union all
select 'C2',null,null,null union all
select 'D2',null,null,null union all
select 'E2',null,null,null
--> 测试数据：[表3]
if object_id('[表3]') is not null drop table [表3]
go
create table [表3]([aaa3] varchar(2),[bbb3] sql_variant,[ccc3] sql_variant,[ddd3] sql_variant)
insert [表3]
select 'A3',null,null,null union all
select 'B3',null,null,null union all
select 'C3',null,null,null union all
select 'D3',null,null,null union all
select 'E3',null,null,null
go
with t
as(
select [aaa1] from [表1]
union all
select [aaa2] from [表2]
union all
select [aaa3] from [表3]
)
select
distinct t.aaa1,a.bbb1,a.ccc1,a.ddd1,b.bbb2,b.ccc2,b.ddd2,c.bbb3,c.ccc3,c.ddd3
from
t,[表1] a ,[表2] b,[表3] c
