2006/11/24, Richard Lynch <ceo@xxxxxxxxx>:
On Fri, November 24, 2006 10:27 am, Yves Tannier wrote: > First, sorry for my bad english ;) > > I'm looking for a simple way to provide query with two table like this > : > > SELECT t1.idperson, t1.lastname FROM table1 t1, table2 t2 WHERE > t1.idperson=t2.idperson AND t1.idperson=2 > > I try with joinAdd and selectAs but its always complexe query like : > > SELECT t1.idperson, t1.lastname FROM table1 t1 INNER JOIN table2 t2 > ect... > > I can't use query() method because I need to use find() method after > (orderBy, Pager, limit ect...) I'm not quite sure what DB_DataObject is, or where it comes from... But wherever that software came from, there is probably a better list/forum/space to ask this, if nobody here answers.
So sorry. It's a mistake ;) I've subcribe on php-general@xxxxxxxxxxxxx but not on pear-general@xxxxxxxxxxxxx DB_DataObject is a pear package. bye. Yves <pear-general@xxxxxxxxxxxxx>
