Hi,
I have a bean: ABean that has a cmr to a BBean. The relation doesn't always exist. I.e., ABean.getB() can return null. BBean has an attribute 'foo' of type string.
I tried doing 'SELECT OBJECT(c) FROM a_schema AS c ORDER BY c.b.foo'
But I only get back those beans that have the relation established (i.e. getB() doesn't return null). Why is that? doing the same thing in sql (with a left join) produced the right results.
Thanx,
Ittay
