How do I implement in HSQL a query like this one:



Many thanks!

Im facing a similar issue of joining a table to itself as the original poster but using Criteria API. Do i need to have a mapping element to produce such a case of table joining to itself?

I couldnt find any reference in the forums. Any pointers greatly appreciated.

Thanks
Raja

Try something like this:

You may also want to change it to be like this:

select user1, user2 from user user1 ,user user2 where user1.id = user2.id

And then when you get your list back, access each row via an object[], unless you have a defined object that contains two users' details.

The object[] would contain two objects, one at 0 and one at 1, you would then just typecast them as user.

-G