Having a strange bug with nested queries
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT BLAH FROM tableC WHERE c1 = 'c' AND c2= 'c' );
this works, but it should not
there is no "BLAH" column in table C
If I change it to this, it works correctly, as far as I can tell, still working on validating data
SELECT A.*, b.*
FROM tablea a WHERE BLAH IN ( SELECT CORCOL BLAH FROM tableC WHERE c1 = 'c' AND c2= 'c' );
the first sql shouldnt even run, when you run the nested query alone, ie SELECT BLAH FROM tableC WHERE c1 = 'c' AND c2= 'c' it failes, column does not exist!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
