Re: Select two table with DB_DataObject
| From: | Yves Tannier | Date: | Fri, 24 Nov 2006 20:39:07 +0000 |
| Subject: | Re: Select two table with DB_DataObject | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-245135@lists.php.net to get a copy of this message | ||
2006/11/24, Richard Lynch <ceo@l-i-e.com>:
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 pear-general@lists.php.net DB_DataObject is a pear package. bye. Yves <pear-general@lists.php.net>