I need to create a view where part of the data is on a different database.
Rentals table is on the table where the view will be created and customers is in a different database.
How can I create a view referencing the two databases?
The databases are on the same server.
Thanks for the help.