Hi,
Is it possible to create sub-queries using DBIx?
I want to do something like:
select me.body, me.date, me.time, me.username from(select me.id, me.body,
me.date, me.time, user.username from forum me join user user
on(me.id_user=user.id) where me.id_room=3 order by date desc, time desc
limit 10) as me order by date asc, time asc\G
Thanks.
Octavian
_______________________________________________
List: [email protected]
Listinfo: http://lists.rawmode.org/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
