I have the following mapping
Resort.class is an Interface mapped to resort table
FamilyResort.class and BusinessResort implement the above interface and mapped by subclass within the Resort mapping.

I have another concrete class EuropeanResort implementing the above Resort interface but mapped to a seperate table called eu_resort in a seperate class tag.

When I query using Resort interface, hibernate is querying the eu_resort as well. I want to avoid this and when I query for Resort interface it should query for only those classes which are defined using subclass and mapped to same table.

How do i achieve this.

I am using Hibernate3