TheFilmGod Posted February 23, 2010 Share Posted February 23, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/193025-multiple-table-joins-to-create-master-event-list-for-sorting/ Share on other sites More sharing options...
fenway Posted February 24, 2010 Share Posted February 24, 2010 Why can't you just UNION all of the tables? Quote Link to comment https://forums.phpfreaks.com/topic/193025-multiple-table-joins-to-create-master-event-list-for-sorting/#findComment-1017483 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.