Yeah, sorry about that. Must have lopped it off when trying to make the SQL readable. Of the 381 Locations, 164 don't have a maintenance event so should return null in the join. The rest of the locations of 1-3 maintenance events that I am trying to get the latest of with Max().