Hello.
Select syntax is correct on my 4.1.10a MySQL instance. EXPLAIN is telling me 'Impossible WHERE' until I put values in the tables so the query could produce at least several rows. After that everything was OK. Graham Anderson <[EMAIL PROTECTED]> wrote: > this sql works on mysql version 3.23.58...my remote server > > SELECT c.City, r.Region, co.Country > FROM subnets s, cities c, regions r, countries co > WHERE c.CityId = s.CityId > AND c.RegionID = r.RegionID > AND c.CountryID = co.CountryId > AND s.SubNetAddress = '24.24.172' > LIMIT 0 , 30 > > > but the same syntax fails on mysql version 4.1.3-beta ...my local > computer > > When I EXPLAIN the sql, I get the error: > Impossible WHERE noticed after reading const table... > > anyone know what this could be ? > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]