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?

Related posts

Recent Viewed