Try WHERE t1.myOtherCol in (
----- Original Message ----- From: "Matt Quackenbush" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Sunday, March 18, 2007 8:17 PM Subject: MySQL Syntax (4.1) > Hello, > > I am receiving a syntax error on this query, and I cannot for the life of > me > figure out why. > > SELECT t1.myCol > FROM myTbl t1 > WHERE t1.myOtherCol = ( > SELECT t2.myOtherCol > FROM myTbl t2 > WHERE t2.myCol = '#myVar#' > ); > > According to the MySQL docs (referenced below) it appears that I have the > syntax correct, but I am obviously missing something here. Any help would > be much appreciated. > > http://dev.mysql.com/doc/refman/4.1/en/comparisons-using-subqueries.html > > > Thanks in advance, > > Matt > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272958 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
