INNER JOIN problem with SQL query

[tvdhoff]

Hi all,

This calendar page uses two database tables: 'calendar'  which holds the appointment info and which is linked using column 'location_id' with table 'locations' which holds the location details.

On the overview page I retrieve appointments using this query which works fine:
[code]
$listAppointmentsQuery="SELECT id,name,DATE_FORMAT(date,'%d-%m-%Y') AS date,time,location_name
                                  FROM calendar INNER JOIN locations USING (location_id)
                                  ORDER BY date DESC";
[/code]

However, when a user deletes a location, the appointments that have that location are not displayed using this query. Is there a way to modify the query so that those entries are displayed (with an empty location) as well?

I'd rather not have to run through all appointments resetting their location_id when a location is deleted....

thanks!

Tim

[king arthur]

Try a left join.

[tvdhoff]

thanks, that helped.