在SQLSERVER查询分析器中这样写: IF OBJECT_ID('vTest') is not null drop view vTest GO CREATE VIEW vTest as SELECT SUM(RepRebate1.oddPrice) AS oddPrice FROM RepRebate1 UNION ALL SELECT SUM(RepRebate2.oddPrice) FROM RepRebate2 UNION ALL SELECT SUM(RepRebate3.oddPrice) FROM RepRebate3 UNION ALL SELECT SUM(RepRebate4.oddPrice) FROM RepRebate4 GOselect * from vTest
IF OBJECT_ID('vTest') is not null
drop view vTest
GO
CREATE VIEW vTest
as
SELECT SUM(RepRebate1.oddPrice) AS oddPrice
FROM RepRebate1
UNION ALL
SELECT SUM(RepRebate2.oddPrice)
FROM RepRebate2
UNION ALL
SELECT SUM(RepRebate3.oddPrice)
FROM RepRebate3
UNION ALL
SELECT SUM(RepRebate4.oddPrice)
FROM RepRebate4
GOselect * from vTest