Select two table with DB_DataObject

["Yves Tannier" <yvestan@xxxxxxxxx>]

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