不行的 在查询定义的 S ELECT 列表中,别名 '_Identify' 循环引用。
s elect [_Identify]+(Se lect max([_Identify]) from {质检不合格明细表}) As [_Identify],'123' as 质检不合格单号,存货编号,存货名称,规格型号,单位,数量,备注 from
(s elect 存货编号,存货名称,规格型号,单位,数量,备注 from (s elect {到货单明细表}.[存货编号],{到货单明细表}.[存货名称],{到货单明细表}.[规格型号],{到货单明细表}.[单位],{到货单明细表}.[数量]-{质检单明细表}.[数量] as 数量,{到货单明细表}.[备注] from {到货单明细表},{质检单明细表}where {到货单明细表}.[存货编号]={质检单明细表}.[存货编号] And {到货单明细表}.[到货单编号]='DH20150816002' and {质检单明细表}.[到货单编号]='DH20150816002') where [数量] not in (0) UNION Se lect 存货编号,存货名称,规格型号,单位,数量,备注 from {到货单明细表} where [存货编号] not In (S elect [存货编号] from {质检单明细表} where {质检单明细表}.[到货单编号]='DH20150816002') and {到货单明细表}.[到货单编号] ='DH20150816002')x