I want to perform a JOIN on a foreign key and have it return the columns from both tables. How do I do that is sqlobject?
When I do: TableA.select(AND(TableB.q.TableAID == TableA.q.id)) it only queries the columns of TableA. I am doing the join because I want the columns from both tables. So how do I do a join and get the columns from both tables? Thanks, Lane Brooks ------------------------------------------------------------------------- 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
