I *think* you'd have to do it using the query method (which is generally frowned upon as a method of last resort). $this->Model->query($sql);
Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 22 Jun 2010, at 06:47, rakeshyadav rakeshyadav wrote: > hi Good Morning All, > > i am trying to execute complex SQL query like this, > > EXPLAIN SELECT * > FROM campaign_store_dates cd, campaigns c, stores s > WHERE ( > cd.campaign_id = c.campaign_id > AND cd.store_id = s.store_id > AND cd.date > BETWEEN '&01-06-2010&' > AND '&01-06-2010&' > ) > > Any one please give me cakephp query > > Thanks in Advance > Rakesh > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to cake-php@googlegroups.com > 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?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com 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?hl=en