2
Vote

Outer Joins

description

Hello, I'm trying to execute this query:
 
var consulta = from b in BD.WF_BITACORA
           join p in BD.WF_PROCESOS
           on b.ID_PROCESO equals p.ID
           join a in BD.WF_ACCIONES
           on b.ID_ACCION_EJECUTADA equals a.ID into acciones
           from acc in acciones.DefaultIfEmpty()
           join u in BD.WF_USUARIOS
           on b.USUARIO_EJECUCION equals u.ID into usuarios
           from us in usuarios
           where b.NO_CIA == "01" &&
                 b.CENTROD == "01" && 
                 b.NO_FACTU == "409022"
           select new { PROCESO = p.NOMBRE, p.ICONO, acc.NOMBRE, USUARIO = us.NOMBRE + " " + us.APELLIDO1 + " " + us.APELLIDO2 };
 
But it displays the error in the attached picture. Do you know what am I doing wrong?
 
Thanks.

file attachments

comments