class Selections extends Zend_Db_Table{ } class Articles extends Zend_Db_Table{ }
$sel = new Selections; $sel->find(2)->findArticles(); Take a look at the manual section Zend_Db_Table Relationships to see how configurate your model to adapt to your db schema (member_id instead of the usual id etc) For the where (G.to_delete) clause AFAIK you will need the Zend_Db_Table_Select which is in incubator. Em Seg, 2007-12-17 às 05:15 -0800, debussy007 escreveu: > Hello, > > In my web application I simply want to get the bookmarked articles of a user > : > > select * from articles G, selections S > where G.id_art = S.art_id > and S.member_id = 2 > and G.to_delete = 0; > > I want to get the result in my model object which extends Zend db table, > "Article" > (And I don't need the returned selections data of the query) > > What is the usual way to do such a thing ? > > Thank you ! -- Abraço, Thiago Ferreira Equipe Técnica CVA-RICESU