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])

Reply via email to