First page
Back
Continue
Last page
Overview
Graphics
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;