16 Sep 2012 by prashant patil 4987
try this:From D In Departments Join C in Courses ON C.ID equals D.CoursesFK Group Join DD in DepartmentDetails on DD.ID equals D.DepartmentDetailsFKselect NEW { D.CommonName, D.CoursesFK, D.DepartmentDetailsFK, D.ID, D.LegalName, C.LegalName as Courses, DD.Courseyear...