Full Outer Join - Save Output in new table

sql, sqlite

Solution

To create the table on the fly:

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

Problem

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; ``` 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? Thanks!

Original source