You sent me a direct email, but I prefer to offer what support I can in here.
Sorry, I can't help with this as I have never used a MySQL Union. I had to search on what a UNION was and cannot come up with a situation where I would need to use it?!? If I had two tables with identical fields I would merge the tables to preserve a normalised database. Paul On Sep 16, 2:17 pm, Sivaramakrishnan S <siva...@nasoindia.com> wrote: > hi, > > Anyone knows a good way to make UNION query in CakePHP? I would like > to avoid using $this->query();. > > for this code => > > "Select distinct bm.id,name, add > From table1 bm, > (Select id bid, count(id) > cnt > from table2 > where status = 'N' > group by id > union all > Select id bid, count(id) > cnt > from table3 > where status = 'N' > group by id > order by cnt > limit 10) ab Where id = > bm.id" -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php