Jump to content

Archived

This topic is now archived and is closed to further replies.

tvdhoff

INNER JOIN problem with SQL query

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.