Selecting Subtype Data
This applies whether your subtype data is stored in the same table as the supertype data or in separate database tables. Set the Create Separate Tables attribute to determine how subtype data should be stored.
If Persons can be Guides, then:
will not only select ALL Guide (subtype) attributes table but also ALL Person (supertype) attributes.
If Persons can be Guides or Staff (subtype set Occupation), and they can be Male or Female (subtype set Gender), then you can retrieve all highly experienced female guides with the following statement:
WHERE experience = 'High'
AND female = 'Y'
In this example, Female is a subtype indicator of the Person supertype table.