Which Transact-SQL statement should you run?

You have a database that contains tables named Customer_CRMSystem and Customer_ HRSystem.

Both tables use the following structure:

The tables include the following records:

Customer_ CRMSystem

Customer_ HRSystem

Records that contain null values for CustomerCode can be uniquely identified by Customer Name.

You need to display customers who appear in both tables and have a proper CustomerCode.

Which Transact-SQL statement should you run?
A .


B .

C .

D .

E .

View Answer

Answer: A