Re: UNION ALL query help

Your union creates a table called rss_feed. This table has 4 columns (page_title, last_update, article and reference) from which you try to select the unknown column 'title'. So basicly, exactly what your db is telling you. If it doesn't make sense, strip the outer select and see what your subquery returns. That should make it more clear. regards On Sat, 2010-04-24 at 20:50 -0400, Ron Piggott wrote: > I am received the error message: > > Unknown column 'title' in 'field list' > > from the query below. I am not understanding what I have done wrong. The > goal of the query is with for a RSS feed determining the 15 most current > articles. > > Ron > > > > SELECT title, content_date, content, reference FROM ( ( > > SELECT page_title, last_update, > 'article', reference FROM > user_pages WHERE > include_in_highlights =1 ORDER BY > last_update DESC > LIMIT 15 > > ) UNION ALL ( > > SELECT blog.entry_title, > blog.entry_date, > blog.entry, > blog.reference FROM blog WHERE > blog_owners_reference =1 ORDER BY > blog.entry_date DESC, blog.reference DESC LIMIT 15 > > ) ) AS rss_feed ORDER BY rss_feed.content_date DESC LIMIT 15 > >