Thanks for the correction :-) I didn't notice that there was a
sub-query, just saw two queries. I will look harder next time.
Regards,
Langdon
[EMAIL PROTECTED] wrote:
> Thats a subquery - and while the newer mysql4.1 and above now supports
> subqueries - cakephp uses a left inner join by default - if you want
> the speed and performance of the subquery youll have to use
> $this->ModelName->query("the SQL string");
> otherwise read the manual/api on setting up query conditions and let
> cake build it with the join
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
