Hibernate version: 3.2.6.

Mapping documents: none (Annotations)

Name and version of the database you are using: MySQL 5.0


I'm kindof stuck building a correct HQL query.
I have 2 classes in a many-to-many relationship.

class Sheet
class Tag

One sheet can have several tags and one tag can be used for several sheets.
Is there a possibility for a HQL query that selects all sheets with a certain collection of tags?

Something like:

FROM Sheet s
WHERE s.tags = (from Tag t where t.id = 1 or t.id = 2)

So select all sheets where the tag collection equals a collection of tags where the tag id is 1 or 2.

Thx already