Update subquery returned more than 1 value.

update targets set [Month] = datepart(month, IssueDate) from issues inner join targets on issues.IssueId = Targets.IssueId