http://groups.google.com/group/cake-php/browse_frm/thread/67e19e17185f7fef/4eaaf5c69630ee9d?lnk=gst&q=join+type&rnum=2&hl=en#4eaaf5c69630ee9d
So there will be an association key 'type' where you can do the left join. That post makes it sound like it's not implemented yet. For now, you could throw that query into $this->Posts->query(); Eric On 2/13/07, Alexander Wegener <[EMAIL PROTECTED]> wrote: > > > > > > and how to to this the object oriented way (with fetchAll()) ?? > > > > many thanks! > > Alex > > > > > > On Tue, 13 Feb 2007 14:59:24 +0100, Kaste <[EMAIL PROTECTED]> wrote: > > > > > >> select posts.id, comments.id, count(comments.id) as commentscount from > > >> posts, comments where comments.posts_id = posts.id where commentscount > = > > >> 0 > > >> group by posts.id; > > >> > > > > > > select p.* from posts p left join comments c on c.post_id=p.id where > c.id > > > is null; > > > > > > > > >> Right? > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---