I have a two databases
Test1 database have table called items
I want this table data in Test2 database
I want to create a view for this table and i have to access the data via view in Test2 database;
Can some one suggest me how to do a view creation
how to get the data from Test1 database items table to Test2 database xxx view
please find the table data in the attachment.