SELECT DISTINCT    a.DetailId,    a.OrderId,    a.ProductId,    pi2.BarCode,    pi1.ProductName,    pi1.productCode,    pi1.spec,    a.UnitId,    ui.UnitName,    SNUM(a.DetailId) as Quantity,    a.Discount,    a.UnitPrice,    a.TaxRate,    a.ProductMoney,    a.TaxMoney,    a.PayableMoney,    a.IsGiveAway,    a.DetailId AS ColGuid,    a.ParentGuid,    a.DetailId AS OrderDetailId,    a.OrderId AS RelevanceOrder,    a.Memo,    pi2.SalePrice AS InitUnitPrice,    a.SEQ,      ---必须包含这个，否则报错    a.Quantity - SNUM(a.DetailId) AS OutQuantityFROM    SaleOrderDetail aLEFT JOIN ProductInfo pi1 ON a.ProductId = pi1.ProductIdLEFT JOIN ProductPrice pi2 ON a.ProductId = pi2.ProductIdAND pi2.unitid = a.unitidLEFT JOIN UnitInfo ui ON a.UnitId = ui.UnitIdWHERE    a.DetailId IN (SELECT COLUMN_VALUE FROM TABLE(SPLITSTR(IDS, ‘,‘)))ORDER BY    a.SEQ ASC