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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272955
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
