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 > t1.idpe

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

[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 : SELECT