I'm doing a
select in MySQL with a three-table
(shown in the lower right quadrant of the below image).
Relevant data in the tables are shown along the left side.
The result is in the upper right quadrant.
(Focus on the things in the red boxes.)
My ideal result is two rows of data, but I'm getting four. I don't know why there are four rows of data.