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 a list of customers that do not appear in the Customer_HRSystem table.

Which Transact-SQL statement should you run?
A .

B .

C .

D .


E .

F .

G .

H .

View Answer

Answer: D