SELECT
inventory.inventoryid,
inventory.inventoryid as item_id,
inventory.order_number,
stock_items.item_code,
stock_items.supplier_item_code as "supplier code",
stock_items.description as "desc",
inventory.qty,
inventory.bar_code_number as Bar_code,
inventory.`picked`
FROM
inventory
Left Join stock_items ON stock_items.stock_itemsid = inventory.stock_itemsid
Left Join unit_type ON stock_items.unit_typeid = unit_type.unit_typeid
Left Join supplier ON supplier.supplierid = inventory.supplierid