如果是sqlserver,视图语法
create view 视图名字 As 你的sql语句
比如
create view 视图名字 As Select 公司, 日期1 As 发货日期,金额1 As 发货金额 from {发货1} Union All Select 公司, 日期2 As 发货日期,金额2 As 发货金额 from {发货1}”,