[PHP] Select two table with DB_DataObject

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 :

Re: [PHP] Select two table with DB_DataObject

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

Re: [PHP] Select two table with DB_DataObject

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