laneys.info Beware of Yankees, drunks, and loose women.

Introduced: CF5

Use by specifying <cfquery dbtype="query"...>.

There are a few bugs, such as the query language features are not 100% SQL92-compliant in CF5.

You must fully specify the table names - no aliasing.
You must alias the columns of your result set, even if they are unique.
You cannot use INNER JOIN syntax.