Hibernate 3.0.5

I am sorry that i totally messed up the description of the problem.

Here is the problem :

The table has 2 columns X1 and X2
Here is samle data for the example:

X1 X2
1 a
1 b
1 c
2 a
2 b
2 c
7 d
8 e


Here is what i tried :
Select count(*) from X xa left join X xb where xa.X2 = xb.X2 and
xa.X1 = '1' or xb.X1 = '2'
I expect an answer of 3.

This query fails with an parse exception. The error message is not helpful.

regards
-Sarab

You have to choose between a cross-product and a join. There seems to be no FK column in your table, so you cannot use a join. I do not use cross-products in HQL, but I suppose it would be something like this:

Not sure about the "count(*) though.