CREATE VIEW VIEW_YZCheck14
WITH ENCRYPTION
AS
SELECT XH AS 单号,MC AS 单据名称,HDA003,HDA004,HDA005,HDB002,HDB003,HDB004,HDB041,HDB005,HDB006,HDB031,HDB032,HDB010,HDB018,WJSL,DCL,CQTS
FROM
--采购未结束
UNION
SELECT HDA001 AS XH,'采购单' AS MC,HDA003,HDA004,HDA005,HDB002,HDB003,HDB004,HDB040,HDB005,HDB006,HDB031,HDB032,HDB010,HDB018,HDB006-HDB018 AS WJSL,HDB006/HDB018 AS DCL,datediff(day, HDB010,getdate()) AS CQTS
FROM DCSHDA
LEFT JOIN DCSHDB ON HDA001=HDB001
WHERE HDB010<CONVERT(varchar(08),DATEADD(DAY,0,GETDATE()),112) AND HDB019='T'
消息 156，级别 15，状态 1，过程 VIEW_YZCheck14，第 8 行
关键字 'UNION' 附近有语法错误。
哪里除了错了

不是都提示你了 ， from union 是什么语法

FROM
--采购未结束
UNION
空的地方是不是误删了什么？