HQL - can i join when the association is backwards?

Question

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 Bs joined onto any As, 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

Answer 1

Is there a reason you can't have

class B {
    @ManyToMany
    A a;
}

?