你的问题仍然令人困惑。有一个查询引用了两个表，但示例数据只显示一个表。
根据你的第一段，你可以得到适当的答案 col1 值为：

SELECT t1.col1, . . .
FROM t1
GROUP BY t1.col1
HAVING SUM(CASE WHEN t1.col2 = 1 THEN 1 ELSE 0 END) = 0;

这个 . . . 用于其他列。然后可以将其插入到另一个表或同一个表中。也许：

INSERT INTO t1 (col1, col2, . . .)
    SELECT t1.col1, 0, . . .
    FROM t1
    GROUP BY t1.col1
    HAVING SUM(CASE WHEN t1.col2 = 1 THEN 1 ELSE 0 END) = 0;

我最终得到了这个解决方案。。。

/****The select query****/
SELECT DISTINCT [Table1].[Col1]
FROM [Table1]
JOIN [Table2] ON [Table1].[Col1] = [Table2].[Col1]
WHERE NOT EXISTS (SELECT [Table1].[Col1], [Table1].[Col2] 
  FROM [Table1]
  WHERE [Table1].[Col1] = [Table2].[Col2] AND [Table1].[Col2] = 1)

/****The Insert query****/
INSERT INTO [Table1]
([Table1].[Col1]
,[Table1].[Col2]
,[Table1].[Col3]
,[Table1].[Col4])
SELECT DISTINCT [Table1].[Col1]
,1
,CURRENT_TIMESTAMP
,0
FROM [Table1]
JOIN [Table2] ON [Table1].[Col1] = [Table2].[Col1]
WHERE NOT EXISTS (SELECT [Table1].[Col1], [Table1].[Col2] 
FROM [Table1]
WHERE [Table1].[Col1] = [Table2].[Col2] AND [Table1].[Col2] = 1)