Actualizar dos tablas iguales en SQL Server

[marcelor1988]

Que estoy haciendo mal?

Código SQL:

UPDATE pruebas.dbo.articulos
SET VALUE=t3.VALUE
FROM
(SELECT VALUES FROM pruebas.dbo.articulos AS T1
LEFT JOIN megamundo_dep24.dbo.articulos AS T2 ON (T1.id_articulos=T2.id_articulos)
WHERE T2.id_articulos IS NOT NULL)
AS t3 WHERE t3.id_articulos = pruebas.dbo.articulos
 

Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'VALUES'.