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
• Using joins
• Using unions
• Using conditional operators
• Managing data types for columns
• Using the CAST function
• Using aggregate functions
• Using group by and having expressions
• Using ORDER BY clauses
• Using aliases
• Handling null values
• Concatenating strings
• Escaping reserved keywords
• Using Queries of Queries with dates
• Understanding Query of Queries performance
• Understanding Query of Queries processing

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;

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | KnowledgeBase | Bug Reporting

Version 7

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/7/htmldocs/00001266.htm

Add Comment