Have you started using containable yet? Without testing this it would seem logical that you could run
$this->Property->find('first', array( 'conditions'=>array('Property.id'=>$property_id), 'contain'=>array( 'Market'=>'Article' ) )); However this would give you multiple sets of articles, linked to each market the property is linked to. If you want one distinct list of articles linked to a set of market_ids then find the market_ids first and then run a find against the ArticleMarket model. For a really good extended explanation of how HABTM really works within CakePHP and when you need to force joins or modelize your join table read teknoids related articles: http://teknoid.wordpress.com/?s=habtm HTH Paul Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en