Previous Topic: Identification of Foreign Keys and TargetsNext Topic: Join Example

Introduction › Foreign Keys › Typical Join

Typical Join

A typical join, one to retrieve all attributes of an entity type, looks like this:

ATTRIBUTE.PARENT_ENTITY_ID=ENTITY_TYPE.ID

See the following figure for the format of a typical join:

You can join the attribute view with either the entity_type view or the entity_subtyp view, because Parent_Entity_ID represents the foreign key of either.