You administer a Microsoft SQL Server 2008 instance that contains two databases named
Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses
the Latin1_General_100_CI_AI collation.
Each database has an Orders table that has the following definition: You need to return
records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL
query should you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D