Application Express User's Guide > Building Queries with Query... > Creating Relationships Betw...
You can create relationships between objects by creating a join. A join identifies a relationship between two or more tables, views, or materialized views.
Topics:
About Join Conditions
Joining Objects Manually
Joining Objects Automatically