That did the trick, thank you both! And yes, it makes sense. I did have to make one modification, just to be clear though, to add the DISTINCT keyword. For some reason it added a few duplicate rows. So I added it, and it now has the right number of rows. So here's my query.
Select...