MySQL Forums
Forum List  »  Spanish

No funciona en MySQL 3.23
Posted by: scrich powers
Date: January 11, 2007 04:58PM

Hola amigos.

He estado buscando por el foro y por Internet y no encuentro solución a este problema (o no he buscado lo suficiente...).

He hecho lo siguiente en MySQL 5 y funciona, pero al probar la página en el servidor de Arsys (MySQL 3.23) me da un error. Aquí os dejo lo hecho:

SELECT *
FROM est_partido LEFT JOIN fotografias USING (id_est_partido)
WHERE id_est_partido IN (select id_est_partido FROM fotogaleria
ORDER BY id_gal DESC) AND galeria = 1 GROUP BY est_partido.id_est_partido

Y aquí el error que muestra la página:

You have an error in your SQL syntax near 'SELECT id_est_partido FROM fotogaleria ORDER BY id_gal DESC) AND galeria = 1 GRO' at line 1

Muchas gracias de antemano :-)

Options: ReplyQuote


Subject
Views
Written By
Posted
No funciona en MySQL 3.23
3665
January 11, 2007 04:58PM
2747
January 11, 2007 07:01PM
2248
January 13, 2007 02:36PM


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.