You have a database named Inventory. Inventory is stored on Microsoft Azure SQL Database and contains a
table named ProductDetails.
For a given product, you need to retrieve the ProductID, Manufacturer, Weight, and ListPrice columns for all of
the items in the ProductDetails table. The solution must ensure that the results can be joined to other tables.
Which Transact-SQL statement should you run?

A.

B.

C.

D.

Explanation:
You can JOIN views with tables. You can use views just like tables in SELECTs.
In SQL, a view is a virtual table based on the result-set of an SQL statement.
A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real
tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were
coming from one single table.