Hi all,

for a whole day I'm trying to build a mapping file in hibernate 2.x which does a non equi join.

I have two tables:

log (
id int primary key,
min_item_id int,
max_item_id int);

and

item (
id int primary key,
...
);

What I need to have is a collection of items for a log-object, i.e. "where id between minItemId and maxItemId" (id from item and min/maxItemId from log).

I tried to play with "set" and a "where" clause but didn't get it to work.

Is it possible at all? And if so could someone be so nice to give me a hint how to solve it? I think I read about this, but couldn't find neither in HIA nor the online docs.

TIA! - Bernd