Consulta con repetidos

[Luis_Adriano_Figo]

Hola!!!

Has intentado agregar un DISTINCT a tu consulta.


---------------------------------------------------------------------------------

select <DISTINCT>
pa.nombre_programa as nombre,
pa.clave_programa_academico as clave
from
DM_PROGRAMA_ACADEMICO pa, dm_programa_acad_campus pc
where
pa.CLAVE_PROGRAMA_ACADEMICO = pc.CLAVE_PROGRAMA_ACADEMICO and pc.ID_CAMPUS=1
GROUP BY pa.NOMBRE_PROGRAMA,pa.clave_programa_academico;

---------------------------------------------------------------------------------