SELECT A0.name,A0.description,A0.id FROM groups A0 INNER JOIN roles A1 ON A0.id=A1.group_id WHERE (A1.user_id = ? )
instead of:
SELECT A0.name,A0.description,A0.id FROM groups A0,roles INNER JOIN roles A1,roles ON A0.id=A1.group_id WHERE (roles.user_id = ? ) AND roles.group_id = A0.id
Anyone have any ideas on a fix/workaround?
On Thursday, October 24, 2002, at 02:59 PM, Scott W.Hill wrote:
Well, the error is different now. It looks like it's trying to inner join on roles twice if I'm reading it right.
--Scott
-- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
