var reportsByAuth =
from d in
(from c in rbaDC.ReportDetails
from d in rbaDC.ReportAuthorizations
where c.id == (d.reportid) && (d.role == "admin" || d.loginid == "a")
select new { c.id, c.displayname, c.name })
join ef in rbaDC.auditreports
on d.id equals ef.reportid
select new { d.id,d.displayname,d.name,ef.favtcol };
Can anybody please tell me if this answer is valid?