Subqueries weren't introduced until 4.1. Check the top of the 4.x doc page for confirmation if you like.
--Ben Doom Matt Quackenbush wrote: > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
