Hi, Is it possible to do subqueries with Mapper?
If I have something like: Product.findAll(...) How can I use it as subquery for another query? What I'm trying to do is: "Select * from Table order by random() limit 6" But this doesn't works in modern SQL implementations (Oracle, PG 8.4) so what I need to do is: "Select * from (select * from Table) order by random limit 6" Cheers. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---