Left join with fallback message?

Left join with fallback message

var join = from d in departments

join e in employees on d.Name equals e.Department into g

from emp in g.DefaultIfEmpty()

select new {

Department = d.Name,

Employee = emp?.Name ?? "No employee"