Using joins

A join operation uses a single SELECT statement to return a result set from multiple, related tables, typically those with a primary key - foreign key relationship. There are two SQL clauses that perform joins:

• WHERE clause ColdFusion supports joins through a WHERE clause.
• INNER JOIN and OUTER JOIN ColdFusion does not support joins through INNER JOIN or OUTER JOIN clauses.

Note: Query of Queries supports joins between two tables only.

View comments in LiveDocs