matt_lists wrote:
Jay Blanchard wrote:
[snip]
the bug is, the nested query on the first statement is ignored
[/snip]
No, it isn't ignored...it just returns a FALSE for the IN statement
False should give no records, it's an "IN ()" sense none match the
condition
instead it gives me every record?!
Not only that, shoudlnt it say "column does not exist?" It does not
return an error, it ignores the whole nested query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]