I have:
class A
{
B b;
}
class B
{
}
I know i can do this:
from A a
join a.b b
but what I need to do is this (pseudo-HQL, it doesn't parse, hence this post):
from B b
left outer join A a on a.b = b
I get "Path expected for join!"
:(
I want a complete list of B
s joined onto any A
s, if they exist. Is this possible?
I can't use a right join because SQLite doesn't support them grrrrr
What can I do to solve this?
Thanks