Say Class A has a getB() method that returns a set of B objects.

in the where clause of this set, I can add filters to restrict the Bs that get returned. is there a way to reference the A table in the where clause, to add additional join conditions?

for instance something like

<set name="b"
where="a.x = b.y and b.deleted = false">

The problem is that a is not part of the query..

Is it possible to accomplish the same thing some other way?

Thanks,

Calin