Re: "find" using HABTM relationship

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 <ready2jam2ni...@yahoo.co.jp> 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 cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---