MySQL Forums
Forum List  »  Newbie

Problem MySQL 4.1.9 ORDER BY
Posted by: sergio Ros
Date: June 16, 2005 08:56AM

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

Options: ReplyQuote


Subject
Written By
Posted
Problem MySQL 4.1.9 ORDER BY
June 16, 2005 08:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.