oh you will want to change the query as follows: select left(c.label,35) as objectid, refObjects.typename, r.objectid as ruleObjectId from container c join container_aRules cr on c.objectid = cr.parentid join ruleForm r on cr.data = r.objectid left join refObjects on left(c.label,35) = refObjects.objectid where cr.typename = 'ruleForm';
Otherwise you will get ALL rules, not just the ruleForm rules. -- You received this message cos you are subscribed to "farcry-dev" Google group. To post, email: [email protected] To unsubscribe, email: [email protected] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
