Left table NOT returning all results

[Battlecat]

Hello:

I have two tables.

Table A has a list of ID numbers and course numbers. (175 rows)
Table B has a list of ID Numbers and Test Scores. (10,000+ rows all unique)



There are 175 rows in Table A. Some Students (6 to be precise) are taking two classes rather than just one. Therefor they are in this simple table twice both ID number and course. Yes I realize that this should not be but it is.

When I do a join of the two tables I get 169 rows returned. Thus I deduce that 6 of my students are not showing. Logically I looked and yes the students who have enrolled in more than one course show only the first course and the second course is omitted.

Can anyone tell my why this is?

Thank you,

[RuralGuy]

Why not post the SQL you are using and someone may see the problem?

[Battlecat]

Solved this.

[RuralGuy]

And what happens if you remove the INNER JOIN as a test?