[步骤]

SELECT               oi.OrderSourceID,os.OrderSourceName,               ad.ID AllocationBillID,               ad.AllocationNumber,               ad.RelationId AS PackageID,               ad.OrginNumber AS OrderCode,               ISNULL(op.TrackNumber,'')TrackNumber,               oi.AmazonShipmentId              FROM               RB_Inventory_AllocationBill ad(NOLOCK)               LEFT JOIN RB_OrderInfo oi(NOLOCK) ON oi.OrderCode = ad.OrginNumber AND ad.CustomerID = oi.CustomerID               LEFT JOIN RB_Procurement_Order_Package op(NOLOCK) ON ad.RelationId = op.ID               JOIN RB_OrderSource os(NOLOCK) ON os.ID = oi.OrderSourceId AND os.CustomerID = oi.CustomerID              WHERE              ad.CustomerID =1 AND oi.IsStockOrder=1 AND (   ad.RelationId in( 72647879 ) OR   op.TrackNumber in( select item FROM CharSplitForIn('D72647879', ','))  OR oi.OrderCode in(select item FROM CharSplitForIn('D72647879', ',') ) ) 

[结果]

[期望]

把 or 拆分成 union 操作拼接 成多条语句