select a.A,a.B,b.D from 表1 a left join 表2 b on a.A=b.C and a.B=b.D union ALL select a.C,D=b.B,B=a.D from 表2 a left join 表1 b on a.C=b.A and a.D=b.B
create view 视图名 as select top 100 percent 列AC=列A,列B,列D=null from 表1 union all select 列AC=列C,列B=null,列D=null from 表2 order by 列AC
--错了一点,改一下 create view 视图名 as select top 100 percent 列AC=列A,列B,列D=null from 表1 union all select 列AC=列C,列B=null,列D from 表2 order by 列AC
SELECT E.A AS 列AC,E.B AS 列B,E.D AS 列D FROM ( SELECT A,B,NULL AS D FROM T1 UNION ALL SELECT C,NULL,D FROM T2 )AS E ORDER BY E.A
忘了你的是个试图了,加上建立试图的前缀 CREATE VIEW MYVIEW AS SELECT E.A AS 列AC,E.B AS 列B,E.D AS 列D FROM ( SELECT A,B,NULL AS D FROM T1 UNION ALL SELECT C,NULL,D FROM T2 )AS E ORDER BY E.A结账吧!呵呵
--測試 create table tb1(列a int,列b int) insert tb1 select 1,100 union all select 1,200 union all select 2,300create table tb2(列c int,列d int) insert tb2 select 1,400 union all select 1,500 union all select 1,600 union all select 2,700 union all select 2,800--查詢 select 列a as 列ac,列b,null as 列d from tb1 union all select 列c as 列ac,null as 列b,列d from tb2 order by 列ac --刪除測試 drop table tb1,tb2
--測試 create table tb1(列a int,列b int) insert tb1 select 1,100 union all select 1,200 union all select 2,300create table tb2(列c int,列d int) insert tb2 select 1,400 union all select 1,500 union all select 1,600 union all select 2,700 union all select 2,800 go--創建視圖 CREATE VIEW dbo.V_Select AS SELECT TOP 100 PERCENT * FROM (SELECT 列a AS 列ac, 列b, NULL AS 列d FROM tb1 UNION ALL SELECT 列c AS 列ac, NULL AS 列b, 列d FROM tb2) a ORDER BY 列acgo --刪除測試 drop table tb1,tb2 drop View V_select
表2 b on a.A=b.C and a.B=b.D
union ALL
select a.C,D=b.B,B=a.D from 表2 a left join
表1 b on a.C=b.A and a.D=b.B
as
select top 100 percent
列AC=列A,列B,列D=null
from 表1
union all
select 列AC=列C,列B=null,列D=null
from 表2
order by 列AC
create view 视图名
as
select top 100 percent
列AC=列A,列B,列D=null
from 表1
union all
select 列AC=列C,列B=null,列D
from 表2
order by 列AC
FROM
(
SELECT A,B,NULL AS D
FROM T1
UNION ALL
SELECT C,NULL,D
FROM T2
)AS E
ORDER BY E.A
CREATE VIEW MYVIEW
AS
SELECT E.A AS 列AC,E.B AS 列B,E.D AS 列D
FROM
(
SELECT A,B,NULL AS D
FROM T1
UNION ALL
SELECT C,NULL,D
FROM T2
)AS E
ORDER BY E.A结账吧!呵呵
create table tb1(列a int,列b int)
insert tb1 select 1,100 union all
select 1,200 union all
select 2,300create table tb2(列c int,列d int)
insert tb2 select 1,400 union all
select 1,500 union all
select 1,600 union all
select 2,700 union all
select 2,800--查詢
select 列a as 列ac,列b,null as 列d from tb1
union all
select 列c as 列ac,null as 列b,列d from tb2
order by 列ac --刪除測試
drop table tb1,tb2
create table tb1(列a int,列b int)
insert tb1 select 1,100 union all
select 1,200 union all
select 2,300create table tb2(列c int,列d int)
insert tb2 select 1,400 union all
select 1,500 union all
select 1,600 union all
select 2,700 union all
select 2,800
go--創建視圖
CREATE VIEW dbo.V_Select
AS
SELECT TOP 100 PERCENT *
FROM (SELECT 列a AS 列ac, 列b, NULL AS 列d
FROM tb1
UNION ALL
SELECT 列c AS 列ac, NULL AS 列b, 列d
FROM tb2) a
ORDER BY 列acgo
--刪除測試
drop table tb1,tb2
drop View V_select