Jay Blanchard wrote:

[snip]


No, it isn't ignored...it just returns a FALSE for the IN statement


[/snip]

More info ....

"The word IN is an alias for = ANY. Thus these two statements are the
same:


SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2);
SELECT s1 FROM t1 WHERE s1 IN    (SELECT s1 FROM t2);

However, NOT IN is not an alias for <> ANY, but for <> ALL. See Section
13.1.8.4, "Subqueries with ALL". "

From http://dev.mysql.com/doc/mysql/en/any-in-some-subqueries.html



I can tell you the sql works fine when I alias the column

the original sql should not work at all, the column does not exist in the table, yet it returns no query error


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to