JOINS

• SELECT * FROM item;

• SELECT * FROM stock;

• SELECT item.description, item.cost_price, item.sell_price, stock.quantity FROM item JOIN stock ON item.item_id = stock.item_id;