I have two databases: US and CAN. They contain the same table structure etc, so you can run the same query against both databases and get the correct results. One database will give results for United States, and the other for Canada.
I have a view that I've created in the US database called NationalAccounts. The view also exists in the Canada database. This is ok for when I need to look at the data seperately.
However, I now have a situation where I need the results combined.
Is it possible to have the NationalAccount view that's located in the US database to pull US data, and to also pull info from the Canada database?