Error executing update with sub-query

Question

I have the following situation, I need to update several fields based on the return of a sub-query that returns a main code. This subconsultation is done with Join in two tables to obtain the code. When performing, I have the following error:

Message 512, Level 16, Status 1, Line 24 The subconsultation returned more than 1 value. This is not allowed when the subconsulta follows =, != , <, <= , >, >= or when it is used as an expression.

This is the consultation:

BEGIN TRANSACTION;
UPDATE Produto SET TpProduto = 'C' WHERE IdProduto = (
SELECT DISTINCT(p.IdProduto)
FROM dbo.Produto p 
JOIN dbo.CodigoProduto  cp ON cp.IdProduto = p.IdProduto
WHERE cp.CdChamada IN(
'3VT9200-4ED30                 ',
'3VT9225-6AC00                 ',
'5SX11207                      ',
'6ES73921AJ000AA0              ',
'8910427                       ',
'9676812                       ',
'CON000280                     '

 )

)

Answer 1

this select return more than one value

SELECT DISTINCT(p.IdProduto)

how to compare

WHERE IdProduto = (vários valores)

this piece here needs to return only one value

SELECT DISTINCT(p.IdProduto)
FROM dbo.Produto p 
JOIN dbo.CodigoProduto  cp ON cp.IdProduto = p.IdProduto
WHERE cp.CdChamada IN(
'3VT9200-4ED30                 ',
'3VT9225-6AC00                 ',
'5SX11207                      ',
'6ES73921AJ000AA0              ',
'8910427                       ',
'9676812                       ',
'CON000280                     '

 )

check if that’s not it.