MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 462 / 860

462 Chapter 22: Using Query of Queries
The following figure shows how the output appears:
Query of Queries user guide
The following sections discuss Query of Queries functionality. If you know SQL or have
interacted with databases, you might be familiar with some of these features.
Using dot notation
ColdFusion supports using dot notation in table names.
Example
If a structure named A contains a field named B, which contains a table named Products, you can
refer to the table with dot notation, as follows:
SELECT tape_ID, length
FROM A.B.Products;
Using joins
A join operation uses a single SELECT statement to return a result set from multiple tables. The
re are two main types of JOIN operations:
•
INNER JOIN
includes in the result set only records that are present in both tables
•
OUTER JOIN includes in the result set all records in one of the tables.
ColdFusion does not support OUTER JOINs, nor does it support the INNER JOIN syntax, as
the following example shows:
SELECT Dog_ID, Breed_ID,
FROM Dogs INNER JOIN Breed
ON Dogs.Dog_ID = Breed.Dog_ID;