Read order line items by multiple order IDs

Gets line items for multiple orders by supplying a comma-separated list of order IDs in the ids parameter within the WITH clause.

SELECT * FROM OrderItems WITH(ids='1111111111111,2222222222222,3333333333333')