Welcome Guest, Not a member yet? Register   Sign In
mysql union all?
#1

[eluser]newbie boy[/eluser]
this code works perfectly in mysql..

how will i use this in CI?

or better yet CI using the Doctrine DQL?

Code:
SELECT id, user_id, music_id, comment, createdat FROM tbl_user_music_comment
UNION ALL
SELECT null AS id, user_id, music_id, null AS comment, createdat FROM tbl_user_music_like
UNION ALL
SELECT null AS id, user_id, music_id, null AS comment, createdat FROM tbl_user_music_listen
UNION ALL
SELECT null AS id, user_id, music_id, null AS comment, createdat FROM tbl_user_music_download
UNION ALL
SELECT null AS id, user_id, music_id, null AS comment, createdat FROM tbl_user_music_playlist
UNION ALL
SELECT null AS id, user_id, music_id, null AS comment, createdat FROM tbl_user_music_recommend
ORDER BY createdat DESC

thanks...


Messages In This Thread
mysql union all? - by El Forum - 05-27-2009, 05:44 AM
mysql union all? - by El Forum - 05-27-2009, 05:46 AM
mysql union all? - by El Forum - 05-27-2009, 06:02 AM



Theme © iAndrew 2016 - Forum software by © MyBB