两条select数据
如下
view1:
name value1 value2 value3 value4
a1 11 12
a2 22 21
a6 54 55
a9 74 12
view2:
name value1 value2 value3 value4
a1 g1 g2
a2 j2 j1
a6 k4 i5
a7 d4 d6
我希望我最后得到的结果如下
name value1 value2 value3 value4
a1 11 12 g1 g2
a2 22 21 j2 j1
a6 54 55 k4 i5
a7 d4 d6
a9 74 12
------解决方案--------------------
----------------------------------------------------------------
-- Author :DBA_HuangZJ(发粪涂墙)
-- Date :2014-05-26 13:24:18
-- Version:
-- Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
-- Apr 2 2010 15:48:46
-- Copyright (c) Microsoft Corporation
-- Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
--
----------------------------------------------------------------
--> 测试数据[view1]
if object_id('[view1]') is not null drop table [view1]
go
create table [view1]([name] nvarchar(4),[value1] nvarchar(4),[value2] nvarchar(4),[value3] nvarchar(4),[value4] nvarchar(4))
insert [view1]
select 'a1',11,12,null,null union all
select 'a2',22,21,null,null union all
select 'a6',54,55,null,null union all
select 'a9',74,12,null,null
--> 测试数据[view2]
if object_id('[view2]') is not null drop table [view2]
go
create table [view2]([name] nvarchar(4),[value1] nvarchar(4),[value2] nvarchar(4),[value3] nvarchar(4),[value4] nvarchar(4))