Re: 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 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...) I'm not quite sure what DB_DataObject is, or where it comes from... But wherever that software came from, there is probably a better list/forum/space to ask this, if nobody here answers. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some starving artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So?