On 6/30/06 7:45 PM, Glenn Gallien wrote: > ... > FROM projects t1 > LEFT OUTER JOIN user_permissions t3 ON(t3.object_id = t2.id) > LEFT JOIN users t4 ON(t3.user_id = t4.id) > LEFT OUTER JOIN group_permissions t5 ON(t5.object_id = t2.id) > LEFT JOIN groups t6 ON(t5.group_id = t6.id), > objects t2 > <--- this seems to be the problem > WHERE ...
How is objects (t2) linked to projects (t1)? Were there conditions in the WHERE clause that linked the two? Can you send me the Perl class definitions for all of the classes involved? -John 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 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
