jonniejoejonson Posted January 20, 2009 Share Posted January 20, 2009 I would like to create a list of a users recent activities like facebook. However instead of creating a recent activities table, i think i will union all the tables and select 20 of the users most recent actions... 1/ Would you union all the tables like this to get recent activities? or would you create a seperate table for recent activities, and then join this table to the appropriate other tables to select the correct data? 2/ if you do go for the union tables, how do you order by? if every table has a column for dateCreated or dateUploaded etc, how can i order my results of the unioned table by the date?. kind regards to any responders J. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 20, 2009 Share Posted January 20, 2009 You'll have to combine the data somehow... UNION provides ways to sort data both before & after the union step. Quote Link to comment 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.