SQL Query Joins Multiple Tables - Results in Duplicate Rows
This means there is 1 to Many relationship on the third table. You either need to add more in your join to make it 1 to 1 or create a crosswalk table to do the same.