T-SQL Getting duplicate rows returned

Answer 1

The JOIN is not the issue, it's doing what it's meant to do with a one-to-many relationship

You could use a GROUP BY statement on your query, or alternatively use a sub-select to return DISTINCT values from the ProgramEnrollments/Program tables.

You don't seem to be using data from the ProgramEnrollments or Program tables so are they needed in the query (I presume they are, just thought I'd ask the question).

Answer 2

You don't actually appear to be using any columns in ProgramEnrollments or Program, so try removing those 2 JOINs.