How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

If you join two tables that both have missing rows, you can combine the effect of a left and a right join by using a full join. ... If desired, reorder the columns of the query and then select Show ...

Next, the SQL query must be created. It joins the two tables SalesOrderHeader and SalesOrderDetail to obtain the customer number ( CustomderId ) and number of products purchased per order ...