You have a database that contains a table named Department. Department contains the
names and locations of each department.
You have a table-valued function named ProjectList() that returns a list of all the projects
assigned to a department. The name of the department is passed as an argument to the
ProjectList() function.
You need to create a query that returns a list of all the department names and the project
names. The solution must return only departments that are associated to projects.
What should you add to the query?

A.
OUTER APPLY

B.
OUTER JOIN

C.
CROSS JOIN

D.
CROSS APPLY