You are developing an application that uses data residing in two databases named Inventory and Accounting on a single Microsoft SQL Server 2012 server.
You plan to provide a record set from tables in the Inventory database. You write the following query:
You need to create this query as a permanent database object that can be joined to other queries. The other queries will be run from the Accounting database. Neither database allows cross-database ownership.
Which Transact-SQL statement should you use?
A.
B.
C.
D.
E.