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 ?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]