VIEWs and TEMP TABLEs

• CREATE VIEW view_in_stock AS SELECT item.item_id, item.description, stock.quantity FROM item LEFT JOIN stock ON item.item_id=stock.item_id;

• SELECT * FROM view_in_stock;