-- Тестовые данные
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t3;

CREATE TEMPORARY TABLE t1 (id INT NOT NULL, value INT NOT NULL);
CREATE TEMPORARY TABLE t2 (id INT NOT NULL, value INT NOT NULL);
CREATE TEMPORARY TABLE t3 (id INT NOT NULL);

INSERT INTO t1 (id, value)
SELECT 1, 1 UNION ALL
SELECT 2, 1 UNION ALL
SELECT 3, 1 UNION ALL
SELECT 4, 1 UNION ALL
SELECT 5, 1 UNION ALL
SELECT 6, 1;

INSERT INTO t2 (id, value)
SELECT 1, 10 UNION ALL
SELECT 2, 11;

INSERT INTO t3 (id)
SELECT 1;

-- Обновить только те строки таблицы t1 которые есть в t2 и в t3 - значениями из t2 

-- I cпособ
UPDATE t1
	SET value = a.value
FROM (
		SELECT t1.id, t2.value FROM t1
			INNER JOIN t2 ON t1.id = t2.id
			INNER JOIN t3 ON t1.id = t3.id) AS a
WHERE a.id = t1.id;

-- II способ
WITH a AS 
(
	SELECT t1.id, t2.value FROM t1
		INNER JOIN t2 ON t1.id = t2.id
		INNER JOIN t3 ON t1.id = t3.id		
)
UPDATE t1
	SET value = a.value
FROM a 	
WHERE a.id = t1.id;

SELECT id, value FROM t1;

-- Тестовые данные
DECLARE  @t1 AS TABLE (id INT NOT NULL, [value] INT NOT NULL);
DECLARE  @t2 AS TABLE (id INT NOT NULL, [value] INT NOT NULL);
DECLARE  @t3 AS TABLE (id INT NOT NULL);

INSERT INTO @t1 (id, [value])
SELECT 1, 1 UNION ALL
SELECT 2, 1 UNION ALL
SELECT 3, 1 UNION ALL
SELECT 4, 1 UNION ALL
SELECT 5, 1 UNION ALL
SELECT 6, 1;

INSERT INTO @t2 (id, value)
SELECT 1, 10 UNION ALL
SELECT 2, 11;

INSERT INTO @t3 (id)
SELECT 1;

-- Обновить только те строки таблицы t1 которые есть в t2 и в t3 - значениями из t2 
UPDATE t1
  SET 
      [value] = t2.[value]
FROM @t1 AS t1
     INNER JOIN @t2 AS t2 ON t1.id = t2.id
     INNER JOIN @t3 AS t3 ON t1.id = t3.id;

SELECT id, [value] FROM @t1