Problemas con cláusula Group By

[Andres95]

Otra alternativa...

Código:

Select a.codigo
      ,sub.Marca1
      ,sub.titulo
      ,sub.familia
      ,sub.subfamilia
      ,sub.pvp
      ,sub.final
      ,a.nombre2
      ,a.observacio
      ,a.imagen
      ,a.peso 
From  articulo As a 
Inner join
(Select a.codigo
      ,m.nombre As Marca1
      ,a.nombre As titulo
      ,f.nombre As familia
      ,s.nombre As subfamilia
      ,Sum(p.pvp) As pvp
      ,Sum(st.final) As final
From articulo       As a 
Inner Join familias As f  ON a.familia=f.codigo
Inner Join subfam   As s  ON a.subfamilia=s.codigo
Inner Join stocks2  As st ON a.codigo=st.articulo  And st.empresa = '01'
Inner Join pvp      As p  ON a.codigo=p.articulo   And p.tarifa   = 'PD'
Left Join marcas    As m  ON a.marca=m.codigo 
Where a.baja='False' 
Group By a.codigo, m.nombre, a.nombre, f.nombre, s.nombre  ) sub
On a.codigo = sub.codigo

Saludos!