Can't perform a UNION ALL MySQL query

[eluser]David Johansson[/eluser]
I'm not sure how you like your result, but it looks like your trying to make the following:

Code:

$this->db->query('(SELECT `post_id` as `id` FROM `blog_comentarios`) UNION ALL (SELECT `id` FROM `blog`) ORDER BY `id` DESC');