On Mon, 4 Aug 2003 12:02:46 -0300, "Fernando Papa" <[EMAIL PROTECTED]>
wrote:
> FROM
> cont_contenido
> ,juegos_config
> ,cont_publicacion
> ,(SELECT max(cp1.fecha_publicacion) as max_pub
> --change here
> FROM cont_publicacion cp1) a --change here
But this calculates the global maximum, not per id_instalacion,
id_contenido, and generar_vainilla as in
> AND cont_publicacion.fecha_publicacion = (SELECT
> max(cp1.fecha_publicacion)
> FROM cont_publicacion cp1
> WHERE cp1.id_instalacion =
> cont_publicacion.id_instalacion
> AND cp1.id_contenido =
> cont_publicacion.id_contenido
> AND cp1.generar_vainilla =
> cont_publicacion.generar_vainilla)
Servus
Manfred
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
