SET NOCOUNT ON

CREATE TABLE t1 (Column1 int)
CREATE TABLE t2 (Column1 int, Column2 int)
CREATE TABLE t3 (Column2 int, Column3 int)

SELECT 'CREATE TABLE t1Combined ('
UNION ALL
SELECT DISTINCT COLUMN_NAME + ' ' + DATA_TYPE + ' ' + CASE WHEN IS_NULLABLE = 'YES' THEN ' NULL, ' ELSE ' NOT NULL, ' END
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME IN ('t1', 't2', 't3')
UNION ALL
SELECT ')'

DROP TABLE t1, t2, t3

USE Northwind
GO

SELECT 'SELECT'
UNION ALL
SELECT	CHAR(9) + '[' + MIN(TABLE_NAME) + '].[' + COLUMN_NAME + '],' 
FROM	INFORMATION_SCHEMA.COLUMNS
WHERE	TABLE_NAME IN ('Customers', 'Orders', 'Order Details')
GROUP BY COLUMN_NAME
UNION ALL
SELECT	'INTO MyNewTable
FROM Customers
     LEFT OUTER JOIN Orders
         ON Orders.CustomerID = Customers.CustomerID 
     LEFT OUTER JOIN [Order Details]
         ON [Order Details].OrderID = Orders.OrderID'

SELECT
	[Customers].[Address],
	[Customers].[City],
	[Customers].[CompanyName],
	[Customers].[ContactName],
	[Customers].[ContactTitle],
	[Customers].[Country],
	[Customers].[CustomerID],
	[Order Details].[Discount],
	[Orders].[EmployeeID],
	[Customers].[Fax],
	[Orders].[Freight],
	[Orders].[OrderDate],
	[Order Details].[OrderID],
	[Customers].[Phone],
	[Customers].[PostalCode],
	[Order Details].[ProductID],
	[Order Details].[Quantity],
	[Customers].[Region],
	[Orders].[RequiredDate],
	[Orders].[ShipAddress],
	[Orders].[ShipCity],
	[Orders].[ShipCountry],
	[Orders].[ShipName],
	[Orders].[ShippedDate],
	[Orders].[ShipPostalCode],
	[Orders].[ShipRegion],
	[Orders].[ShipVia],
	[Order Details].[UnitPrice],  -- Delete this final comma
INTO MyNewTable
FROM Customers
     LEFT OUTER JOIN Orders
         ON Orders.CustomerID = Customers.CustomerID 
     LEFT OUTER JOIN [Order Details]
         ON [Order Details].OrderID = Orders.OrderID