Copy Data from a table in one Database to another separate database

SELECT … INTO creates a new table. You’ll need to use INSERT. Also, you have the database and owner names reversed.

INSERT INTO DB1.dbo.TempTable
SELECT * FROM DB2.dbo.TempTable