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 create a list of all unique customers that appear in either table.

Which Transact-SQL statement should you run?
A .

B .

C .

D .

E .


F .

G .

H .

View Answer

Answer: E