Help with a query

Hi to all,
Im using a query like this:
select A.AfectadoApellidos as Apellido, A.AfectadoName,
A.AfectadoDNI,(Convert(varchar,TA. TipoAccionBreve)+Convert(varchar,Empresa
s.
EmpresaBreve)+Convert(varchar,E.ExpedienteIncidenciaID)) as Codigos
from Expedientes E
inner join Afectados A on E.AfectadoID=A.AfectadoID
inner join Empresas on E.EmpresaID=Empresas.EmpresaID
inner join TiposAccion TA on E.TipoAccionID=TA.TipoAccionID
group by A.AfectadoApellidos,
A.AfectadoName,A.AfectadoDNI,E.ExpedienteIncidenciaID,Empresas.EmpresaBreve,
TA.TipoAccionBreve
and im getting this result:
Apellido AfectadoName AfectadoDNI Codigos
-- -- -- --
Surname1 Name1 DNI1 CodeAAA
Surname2 Name2 DNI2 CodeBBB
Surname2 Name2 DNI2 CodeCCC
I would like to get anything like this
Apellido AfectadoName AfectadoDNI Codigos
-- -- -- --
Surname1 Name1 DNI1 CodeAAA
Surname2 Name2 DNI2 CodeBBB--CodeCCC
How could i get only a row for the name 2 surname 2?
--
Thanks a lot.
Regards.
JosemaCheck this.. For the concat string stuff...
[url]http://omnibuzz-sql.blogspot.com/2006/06/concatenate-values-in-column-in-sql.html[
/url]
-Omnibuzz (The SQL GC)
"Josema" wrote:

> Hi to all,
> Im using a query like this:
> select A.AfectadoApellidos as Apellido, A.AfectadoName,
> A.AfectadoDNI,(Convert(varchar,TA. TipoAccionBreve)+Convert(varchar,Empresa
s.EmpresaBreve)+Convert(varchar,E.ExpedienteIncidenciaID)) as Codigos
> from Expedientes E
> inner join Afectados A on E.AfectadoID=A.AfectadoID
> inner join Empresas on E.EmpresaID=Empresas.EmpresaID
> inner join TiposAccion TA on E.TipoAccionID=TA.TipoAccionID
> group by A.AfectadoApellidos,
> A.AfectadoName,A.AfectadoDNI,E.ExpedienteIncidenciaID,Empresas.EmpresaBrev
e,
> TA.TipoAccionBreve
>
> and im getting this result:
> Apellido AfectadoName AfectadoDNI Codigos
> -- -- -- --
> Surname1 Name1 DNI1 CodeAAA
> Surname2 Name2 DNI2 CodeBBB
> Surname2 Name2 DNI2 CodeCCC
>
> I would like to get anything like this
> Apellido AfectadoName AfectadoDNI Codigos
> -- -- -- --
> Surname1 Name1 DNI1 CodeAAA
> Surname2 Name2 DNI2 CodeBBB--CodeCCC
>
> How could i get only a row for the name 2 surname 2?
> --
> Thanks a lot.
> Regards.
> Josema|||If you don't need the concat and any row is fine, then you may use this..
select A.AfectadoApellidos as Apellido, A.AfectadoName,
A.AfectadoDNI,min(Convert(varchar,TA.TipoAccionBreve)+Convert(varchar,Empres
as.EmpresaBreve)+Convert(varchar,E.ExpedienteIncidenciaID)) as Codigos
from Expedientes E
inner join Afectados A on E.AfectadoID=A.AfectadoID
inner join Empresas on E.EmpresaID=Empresas.EmpresaID
inner join TiposAccion TA on E.TipoAccionID=TA.TipoAccionID
group by A.AfectadoApellidos, A.AfectadoName,A.AfectadoDNI
Hope this helps.
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/