Update error. Subquery returned more than 1 value

1

Hi friends. how can i fix that?

;with cte
as
(select distinct(e.Id )
from SecurityKmsAbfa..EnterprisePositions e
join SecurityKmsAbfa..Import_UsersTeh i on e.Name=i.vahedeSazmani
join NewKmsAbfa..Members m on m.SSN=i.kodeMelli
)

update SecurityKmsAbfa..users
set EnterprisePositionId = (select id from cte )
from SecurityKmsAbfa..Import_UsersTeh i
join NewKmsAbfa..Members m on m.SSN=i.kodeMelli
join SecurityKmsAbfa..users u on u.Id=m.id
where u.EnterprisePositionId is null

error:
Msg 512, Level 16, State 1, Line 3
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

2 
SELECT id FROM cte

This is going to return all of the rows from the CTE query.
You'll need to filter it or limit it in some way so that it can only return 1 row.

It's difficult to recommend a change because I can't tell what you are trying to do.