Database1 has table1, database2 has view.

view contain select data from table_n. The both database are on the same server.

E.g

Query is:

on database1

insert into table2 select * from database2.dbo.view

select * from Table1...