How do I achieve the same as the query below then? SELECT a.id, a.title FROM sites a, site_users b, users c WHERE a.id = b.site_id AND c.id = b.user_id AND c.id = 7
It seems odd that the HABTM relationship doesn't enable it. On Nov 25, 1:58 pm, Kyo <[EMAIL PROTECTED]> wrote: > You can't put User conditions in the Site query. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
