from u in Users join UserHistory on u.masterID equals h.masterID into h select new { u.masterID, u.user, Created = h.Select(x => x.created).OrderByDescending(c => c).FirstOrDefault() }
Or, with an association:
from u in Users let created = u.UserHistories.Select(x => x.created).OrderByDescending(c => c).FirstOrDefault() select new { u.masterID, u.user, Created = created }
Amy b
source share