LINQ to SQL "complex" select

Question

I have Country=>Ligue=>Team(Name, Score)

I need to select all team Name-Scores from a country.

something like this, does not work )

query = from ligue in myCountry.Ligues, from team in ligue.Teams select name = team.Name, score = team.Score distinct

EDIT:

VB.NET syntax is preferable.

Answer 1

Using jeroenh's code, that used Kirk's code, here is the working version (VB.NET)

  Dim query =  From ligue In myCountry.Ligues
               From team In ligue.Teams
               Select Name = team.Name, Score = team.Score 
               Distinct