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: