SqlServer?oracle?mysql?
--------------
SELECT A.*,(CASE WHEN ISNULL(B.物料情况,'')='' THEN A.物料情况 ELSE 'NG' END) [NEW_] FROM 表 A LEFT JOIN (
SELECT 订单号 FROM 表 WHERE 物料情况='NG') B ON A.订单号=B.订单号
https://blog.csdn.net/weixin_43131692/article/details/113744780