SELECT
stock_items.stock_itemsid,
stock_items.item_code as company_code,
stock_items.supplier_item_code as supplier_code,
stock_items.bar_code_number as 
bar_code_number,
stock_items.cost_price_excluding_vat as cost,
stock_items.selling_price_excluding_vat as 'sell/u',
item_catagory.description as Cat,
stock_items.account_noid,
stock_items.description
FROM
stock_items
Left Join item_catagory ON item_catagory.item_catagoryid = stock_items.item_catagoryid
Left Join item_sub_catagory ON item_sub_catagory.item_sub_catagoryid = stock_items.item_sub_catagoryid
