2006/11/24, Richard Lynch <[EMAIL PROTECTED]>:
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@lists.php.net but not on [EMAIL PROTECTED] DB_DataObject is a pear package. bye. Yves <[EMAIL PROTECTED]>