在查询的数据前面都加一个超期字段

DISTINCT NAME1 as 供应商名称,
YHJDH as 要货单号,

'超期' as 类别

FROM
ZMM068
WHERE
(MENGE_ASN <> '0')
AND (LFDAT = '2025-06-16')
AND (CPUDT = '')