[SQL] Excess data, excess combination of data at JOIN - SQL

I need to join multiple tables to retrieve more information about the main parameters. However, when I perform the join, the resulting table includes combinations of dates, which I don't need. I only want the main true date values, and I need help removing the unwanted combinations of parameters.

from AML_Indicators ind

left join AML_scoring_types types
on ind.ScoringTypeID = types.id

LEFT JOIN AML_CR_Schema_Details details
ON ind.name = details.name AND details.SchemaID IS NOT NULL

left join AML_CR_Schemas sch
on sch.SchemaID=details.SchemaID

left join AML_Indicator_Question_Mapping mpp
on ind.id = mpp.IndicatorID

join AML_Indicator_Ranges rng
on mpp.id = rng.MappingID

left join AML_Risk_Groups risk
on rng.RiskID = risk.ID
where ind.name = 'residency'
order by sch.SchemaID


and the result Combination

Continue reading...