SQL view definition sample:

SELECT item_num AS [name], StockQty, standard FROM itemMaster