score:1

Accepted answer
var innerJoinResult = 
    Articles.Join(ArticleTags.Where(x => x.TagId == 8),
                  a => a.Id,
                  at => at.ArticleId,  
                  (a, at) => a);

score:0

articleTags.Where(a => a.Tag.id = 8).Select (a -> a.ArticleTag );

Related Query

More Query from same tag