One benefit of ColdFusion is the ability to query a query, normally saving another trip to the DB. But just remember that it has a limited subset of the SQL SELECT. To find them all check out the LiveDocs athttp://livedocs.macromedia.com/coldfusion/5.0/Developing_ColdFusion_Applications/queryDB11.htm