Oooops. I just found out that this particular database is actually 4.0.27, and not 4.1. According to a few articles that I've found, the 1064 error code indicates a "MySQL version mismatch", with specific regard to reserved words. That is making me think that 4.0.27 does not support subqueries. However, the docs that I referenced in the original post are allegedly for v3.23, 4.0, and 4.1.
Can anyone confirm whether or not 4.0.27 supports subqueries? Thanks, Matt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
