I need some help on implementing the below query for $this->paginate()
SELECT * FROM `table1` WHERE name like '%n3%' AND code NOT IN ( SELECT code FROM table2 ) UNION SELECT * FROM table2 where name like '%n3%' I want to get the paged resultset and count value also. -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php?hl=en. For more options, visit https://groups.google.com/groups/opt_out.