Hi, I think this is an error, anyways i'm trying to join 6 tables together. and when i do EXPLAIN SELECT i get the message in comments
""Impossible WHERE noticed after reading const tables"" this is my statment basically SELECT table1.id FROM table1,table2,table3,table4,table5,place WHERE table1.col1 BETWEEN 150 AND 196 AND table1.col2 BETWEEN 50 AND 77 AND table1.col3 IN ( 2 ) AND table2.col1 IN ( 3 ) AND table2.col2 IN ( 14 ) AND table2.col3 IN ( 3 ) AND table3.col1 IN ( 1 ) AND table3.col2 IN ( 1 ) AND table3.col3 IN ( 04 ) AND table4.col1 IN ( 3 ) AND table4.col2 IN ( 2 ) AND table4.col3 IN ( 1 ) AND table5.col1 IN ( 1 ) AND table5.col2 IN ( 1 ) AND table5.col3 BETWEEN 18 AND 41 AND place.longitude BETWEEN - 100.310005083878 AND - 91.6899949161224 AND place.latitude BETWEEN 66 AND 29.385577346152 AND 3963 * ( acos( sin( radians( place.latitude ) ) * sin( radians( 33.0000000000 ) ) + cos( radians( place.latitude ) ) * cos( 33.0000000000 ) * cos( radians( - 96.0000000000 - place.longitude ) ) ) ) <= 250 AND table1.id = table2.id AND table2.id = table3.id AND table3.id = table4.id AND table4.id = table5.id AND table5.id = place.id Any help is appreciated. Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
