Examplre of Inner Join function in mysql

1. SELECT foods.item_name,foods.item_unit,  
2. company.company_name, company.company_city  
3. FROM foods ,company  
4. WHERE  foods.company_id =company.company_id  
5. AND company.company_city='London';