You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Prod.
You have been instructed to join two tables on a column called ABC_Common. You have to
ensure that the values in the columns being joined are compared using a comparison operator.
Which of the following actions should you take?

A.
You should consider making use of a full outer join

B.
You should consider making use of an right outer join

C.
You should consider making use of a cross join

D.
You should consider making use of an inner join.

Explanation: