mysql joining empty rows?

Question

i have this query

SELECT cities.city, city_date.date_avail 
FROM cities, city_date 
WHERE city_date.city_id = cities.id;

but i would like the query to return all the cities from cities even if they dont have a city_date associated with it?

Arnaud F. · Accepted Answer · 2011-01-31 11:40:47Z

4

see OUTER JOINS ;) (RIGHT / LEFT / FULL)

SELECT cities.city, city_date.date_avail
FROM cities
LEFT OUTER JOIN city_date ON city_date.city_id = cities.id;

answered Jan 31, 2011 at 11:40

Arnaud F.

8,51212 gold badges58 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1