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 Cartesian product, combining both tables.

Which Transact-SQL statement should you run?
A .

B .

C .

D .

E .

F .

G .


H .

View Answer

Answer: G