update con el resultado de un select

[Libras]

Código MySQL:

UPDATE tmp_venedors 
SET normal_completa_unidades = completa.operaciones, 
    normal_completa_importe = completa.impvta, 
     normal_completa_dto_medio = completa.avgdto, 
     normal_completa_vtamedia = completa.vtamedia
FROM
( SELECT vendedorVta, COUNT(*) AS operaciones, SUM(impnetoVta) AS impvta,  
         round(avg(impdtoVta),2) AS avgdto, round(avg(impnetoVta),2) AS vtamedia
FROM encargos t
WHERE anuladaVta<>"S" AND fechaVta BETWEEN '2018-07-01' AND '2018-07-31' AND promocionVta=0 AND TRIM(monturaVta)>''
GROUP BY vendedorVta ) as completa
 
WHERE vdor=completa.vendedorVta