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