Hi, I've a problem with a SELECT in LINUX S.O.. When I execute this SELECT in Windows Operating Syetem
the SELECT work OK but don't work correctly in Linux operating system. MySQL versión is 4.1.9 in both computers.
The problem is that this SELECT dom't order correctly by Precio_INM (Linux Computer S.O.)
Please if is posible help me, Thanks
The original Select is this :
(SELECT * FROM inmuebles LEFT JOIN municipios ON inmuebles.Poblacion_INM = municipios.CP_MUN LEFT JOIN agencias ON inmuebles.IDAGE_INM = agencias.ID_AGE
WHERE foto1 != '' AND Activo_INM != 'N' AND (Pack_AGE = 'P-100' OR Pack_AGE = 'P-50')
ORDER BY Precio_INM ASC)
UNION ALL
(SELECT * FROM inmuebles LEFT JOIN municipios ON inmuebles.Poblacion_INM = municipios.CP_MUN LEFT JOIN agencias ON inmuebles.IDAGE_INM = agencias.ID_AGE
WHERE foto1 != '' AND Activo_INM != 'N' AND Pack_AGE = 'P-20'
ORDER BY Precio_INM ASC) LIMIT 0, 10
Sorry but I don't write correctly English
Best Regards
Sergio Ros
webmaster@srvwebmaster.com