sql query

[shere]

selecting data (columns) from two different tables and then
creating new table and placing selected columns in the created table.

[flann]

SELECT tbl1.field1, tbl1.field2, tbl2.field3
FROM table1 as tbl1
INNER JOIN table2 as tbl2 ON tbl1.table1ID = tbl2.table1ID

Then use the create table to create a new table as you loop through the results of this.

[mattyblah]

What RDBMS are you using? you can use select into with SQL Server.