Sorry Guy,

was just a little tired yesterday.

> Err... you're right... one of us say the same thing when I show the
> Volker mail...

Try to make a group by in the inline-view, so you will get something
like this:

> 
> On Mon, 4 Aug 2003 12:02:46 -0300, "Fernando Papa" <[EMAIL PROTECTED]>
> wrote:
> >      FROM 
> >      cont_contenido   
> >      ,juegos_config    
> >      ,cont_publicacion 
> >      ,(SELECT id_instalacion,
                id_contenido,
                generar_vainilla,
                max(cp1.fecha_publicacion) as max_pub  
         FROM cont_publicacion cp1
         GROUP BY id_instalacion,id_contenido,generar_vainilla) a  
where 
  ...
  AND a.id_instalacion = cont_publicacion.id_instalacion
  AND a.id_contenido = cont_publicacion.id_contenido
  AND a.generar_vainilla = cont_publicacion.generar_vainilla
  AND a.max_pub = cont_publicacion.fecha_publicacion 


Sorry for this missing group.

Bye,

Volker

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to