On Sun, Aug 27, 2006 at 05:07:19PM -0300, Jorge Godoy wrote:
> What I need is a JOIN. I believe I can't have it automatically done without
> resorting to sqlbuilder... In SQL it would be:
>
> SELECT classone.* FROM classone c1, classone_classtwo c1c2 WHERE
> c1c2.classone_id = c1.id AND c1c2.classtwo_id = <CONDITION>;
>
> I.e., filter results from ClassOne due to its relationship with ClassTwo in
> the intermediate table.
No, SQLObject currently cannot do such joins.
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
