Tricky Join

[NancyJ]

I'm joining 3 tables, but I need to get results even if theres nothing in the 3rd table.


SELECT event.id, event_times.id as event_time_id, name, count(event_entries.bird_id) as num_entrants, event_times.datetime, event.fee, event.fund FROM contests
JOIN event_times on event.id = event_times.event_id
JOIN event_entries on event_entries.event_id = event_times.id
WHERE user_id = 1 group by event_times.datetime


whichever join type I try I get 0 results.

Each entry in the first table (event) can have many items in event_times and each event_times entry can have multiple entries in event_entries

[guelphdad]

You need to use a LEFT OUTER JOIN on any table you want all results from, even when no matching results occur on the next joined table.