Originally Posted by redwhiteandblue

select * from model, city
left join model_in_city on model.model_id=model_in_city.model_id
left join city on city.city_id=model_in_city.city_id