Select two table with DB_DataObject
| From: | Yves Tannier | Date: | Fri, 24 Nov 2006 16:27:04 +0000 |
| Subject: | Select two table with DB_DataObject | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-245122@lists.php.net to get a copy of this message | ||
Hi,
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...)
Any solution ?
Thanks !
Yves