in expected: p [select c.Id_Con, c.Id_Per, p.Nombres_Per , p.ApellidoPaterno_Per, c.Id_Cti, c.Fecha_Con, c.Observacion_Con, c.Estado_Est, c.Id_Ven
from crmos.Bo.Contacto c
inner join Persona p
on c.Id_Per=p.Id_Per
order by c.Id_Con desc]
Update 29/10/2008Ahora tengo este otro error:
outer or full join must be followed by path expression [select c.Id_Con, c.Id_Per, p.Nombres_Per , p.ApellidoPaterno_Per, c.Id_Cti, c.Fecha_Con, c.Observacion_Con, c.Estado_Est, c.Id_Ven from crmos.Bo.Contacto as c inner join crmos.Bo.Persona as p on c.Id_Per=p.Id_Per order by c.Id_Con desc]
Creo que lo que provoca este error es el uso de INNER JOIN, por lo que reemplaze esta consulta que usa INNER JOINselect c.Id_Con, c.Id_Per, p.Nombres_Per , p.ApellidoPaterno_Per, c.Id_Cti, c.Fecha_Con, c.Observacion_Con, c.Estado_Est, c.Id_Ven
from Contacto as c
inner join Persona as p on c.Id_Per=p.Id_Per order by c.Id_Con desc
por esta consulta:
select c.Id_Con, c.Id_Per, p.Nombres_Per , p.ApellidoPaterno_Per, c.Id_Cti, c.Fecha_Con, c.Observacion_Con, c.Estado_Est, c.Id_Ven from Contacto as c , Persona as p where c.Id_Per=p.Id_Per order by c.Id_Con desc
No hay comentarios:
Publicar un comentario