service/QC/OaApi.cs
@@ -112,7 +112,9 @@ C.item_name AS jzmcwlmc, D.supp_name AS khgys, B.bill_no AS dhdhmes, A.remark AS bhgpqxms (SELECT STRING_AGG(releaseNo+':' + mx.fng_desc+'\n', ',') AS OrderIDs FROM [Mes_QC_Exceptional_Detail] mx where mx.pGuid=a.guid ) AS bhgpqxms FROM Mes_QC_Exceptional A LEFT JOIN MES_INV_ITEM_ARN B ON A.aboutGuid = b.guid LEFT JOIN MES_ITEMS C ON A.itemId = c.item_id
