ODBC guide

Read multiple inventory items by IDs


Gets multiple inventory items by supplying a comma-separated list of IDs in the Ids parameter within the WITH clause.

select * from InventoryItems WITH(Ids='43512280416356, 43512280449124')