Hey guys! I have a Many-to-many relation that works as I want to, everything fine. My Question now: I want do a query like
SELECT * FROM robot INNER JOIN robot_mm_parts ON ( robot.uid = robot_mm_parts.uid_local AND robot_mm_parts.uid_foreign = 4);
robot_mm_parts.uid_foreign is the uid of the RobotParts table. So in other word: I want all robots with a certain robot part, how can I realize this with "Robots->find()"?
Thanks for helping me!