Is there any way to get Cake to generate a subquery instead of a table name in a join clause?
e.g. SELECT ... FROM (SELECT .. FROM ... WHERE ...) AS table1 JOIN table2 ON ... WHERE ... For one specific call this form runs much faster than a regular join. It can be can done by generating the SQL and calling query(), but I'm curious to know if it can be done using the Cake infrastructure. Thanks Mark --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
