If you don't want to use a union query, how about using separate queries and adding the rows together?
On Thursday, July 12, 2012 10:13:57 AM UTC+1, Najtsirk wrote: > > I plan to have homeworks also, which would have different data model than > content course. I would like to put everything in the same timeline, > whether is a course content (text, video) or course homework > (questionnaires, uploads etc.). > > Let say steps 1-5 are course contents and than step 6 is homework, than > steps 7-12 are contents, step 13 homework etc. > > On Thursday, 12 July 2012 04:59:18 UTC+2, pbreit wrote: >> >> I don't see any reason to have more than one table "course" at this >> point. Just add a course_type=video|text (I don't think you can name a >> field "type"). > >