LINQ in .NET returning duplicate rows from a working SQL view ... AS users FROM table1 AS a INNER JOIN table2 AS b ON a.Id = b.Id GROUP BY b ... it simply took the first column in the table.