1

Topic: [HQL] to Check up entrance of one set in another

Prompt analog IN for two sets. It is necessary to check up that (1,2,3) IN (0,1,2,3,4,5).

2

Re: [HQL] to Check up entrance of one set in another

Hello, Adnin, you wrote: A> Prompt analog IN for two sets. It is necessary to check up that (1,2,3) IN (0,1,2,3,4,5). And what SQL already so is able?

3

Re: [HQL] to Check up entrance of one set in another

Hello, Blazkowicz, you wrote: B> Hello, Adnin, you wrote: A>> Prompt analog IN for two sets. It is necessary to check up that (1,2,3) IN (0,1,2,3,4,5). B> And what SQL already so is able? Found the decision on SQL with  comparing of the size of a product of sets (INTERSECT, COUNT). HQL does not support INTERSECT, on  I think, can as that on another it is possible.

4

Re: [HQL] to Check up entrance of one set in another

Hello, Adnin, you wrote: A> Found the decision on SQL with  comparing of the size of a product of sets (INTERSECT, COUNT). And why a question about IN then? A> HQL does not support INTERSECT, on  I think, can as that on another it is possible. Through JOIN it is possible. But is easier on SQL to write and  to object. What for HQL?