如何在SQL Server中不添加新行的情况下从两个临时表中获取数据并插入到第三个表中

CREATE TABLE #temp1 (
  column1 datatype,
  column2 datatype,
  ...
);

INSERT INTO #temp1 (column1, column2, ...)
VALUES (value1, value2, ...);

CREATE TABLE #temp2 (
  column1 datatype,
  column2 datatype,
  ...
);

INSERT INTO #temp2 (column1, column2, ...)
VALUES (value1, value2, ...);

INSERT INTO final_table (column1, column2, ...)
SELECT t1.column1, t1.column2, ...
FROM #temp1 t1
JOIN #temp2 t2 ON t1.columnX = t2.columnY
WHERE condition;

INSERT INTO final_table (column1, column2, ...)
SELECT t1.column1, t1.column2, ...
FROM #temp1 t1
JOIN #temp2 t2 ON t1.columnX = t2.columnY
WHERE condition
AND NOT EXISTS (
  SELECT 1
  FROM final_table ft
  WHERE ft.columnX = t1.columnX
);