That depends on what you actually want to do - that won't work at all.
If you are trying to retrieve a subset of the records based on a criteria then perhaps:
string queryStr = "SELECT * FROM Inventory WHERE foodID= @fID AND inventoryID= @iID";
If you are trying to order all the records by two columns then try:
string queryStr = "SELECT * FROM Inventory ORDER BY foodID, inventoryID";
If you want some combination, then you need to explain exactly what combination you are looking for.