On Mon, Sep 18, 2006 at 09:02:19AM -0400, Lane Brooks wrote: > When I do: > > TableA.select(AND(TableB.q.TableAID == TableA.q.id)) > > it only queries the columns of TableA.
That's right. SQLObject maps a class to a table, and the class instances to rows *of that table*. There is no a class corresponding to a join because there is no place to declare columns of the joined rows. > So how do I do a join and get the columns from both tables? http://sqlobject.org/FAQ.html#how-can-i-do-a-left-join Or you can use sqlbuilder.Select() - it allows one to select any columns. But it has other limitations. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
