how to create a linq query using join and max

I have 2 tables in my linq dbml. One is people with a uniqueid called peopleid and the other is a vertical with a foreign key for peopleid and a uniqueid called id. I need to create a type of linq query that does 开发者_运维问答a left outer join on people and gets the latest record in the vertical table based off the max(id) column. Can anyone suggest what this should look like? Thanks.

---

It should look like this (just a suggestion):

from p in con.Peoples
orderby p.LastName , p.FirstName
let maxPrint = p.FingerPrints
   .OrderByDescending(fp => fp.Id)
   .FirstOrDefault()
where maxPrint != null
select new {
  p.PeopleID,
  Name = p.FirstName + " " + p.LastName,
  FingerPrint = maxPrint
};