Jump to content

Multiple Table Joins to create Master Event List for sorting


TheFilmGod

Recommended Posts

I am making a calendar application for my website.

 

I have one master "events" table which has all the information for all the events - this part isn't difficult. The hard part is syndicating the appropriate events to each user (everything is customizable). There are three "intermediate" tables which connect users with the events. Joining these tables with the master table (individually) to get the event information isn't difficult. It is however, very difficult to join all of them at once to get a master selection.

 

I want to be able to sort all the events syndicated to a specific user by date from all three intermediate tables. How would I go around doing this?

 

Here is a layout of the databae:

 

 

Class_events

 

network_id

grade

event_id

 

 

EC_events

 

network_id

ec_id

event_id

 

 

school_events

 

network_id

event_id

 

 

events

 

event_id

all the event information stuff in this table

Archived

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

×
×
  • Create New...

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.