You develop a Microsoft SQL Server 2012 database that has two tables named SavingAccounts
and LoanAccounts. Both tables have a column named AccountNumber of the nvarchar data type.
You use a third table named Transactions that has columns named TransactionId AccountNumber,
Amount, and TransactionDate. You need to ensure that when multiple records are inserted in the
Transactions table, only the records that have a valid AccountNumber in the SavingAccounts or
LoanAccounts are inserted. Which Transact-SQL statement should you use?

A.
Option A

B.
Option B

C.
Option C

D.
Option D