全外连接 - 在新表中保存输出 [英] Full Outer Join - Save Output in new table

问题描述

我想将两张表合并为一张.

I have two tables that I'm trying to join into one.

我成功运行了以下代码.

I ran the following code successfully.

SELECT * FROM combined
LEFT OUTER JOIN isbn_price
ON combined.isbn13 = isbn_price.isbn;

我的问题是如何将此输出保存到新表中?或者甚至将来自 isbn_price 的连接列附加到组合表中?

My question is how do I save this output into a new table? Or even append the joined columns from isbn_price onto the combined table?

谢谢！

推荐答案

动态创建表格:

SELECT * 
INTO NewTable
FROM combined
LEFT OUTER JOIN isbn_price
ON combined.isbn13 = isbn_price.isbn;

这篇关于全外连接 - 在新表中保存输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！