I have the following code and for some reason the left outer join is not producing the correct results.
Dim StudentCourseList = From stud in students Group Join cour in courses on stud.id equals cour.id into joinedlist = Group From j in joinedlist.defaultifempty select stud
The count before the left outer join of students is 12 and courses is 4. However, after the join, the student count is 14 due to some reason. It should be 12 if not less than 12. Am I doing something wrong here?