Select two table with DB_DataObject

From: 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

« previous php.general (#245122) next »