Single Choice Easy

QYou are writing a query to retrieve the customers that are not associated with a sales order. What join between the Customer table and the Sales table should you use?

ID: #11014 Database Manipulation in D365 F&O X++ 249 views

Question Info

#11014Q ID

EasyDifficulty

Database Manipulation in D365 F&O X++Topic

Start Quiz on This Topic

Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

Correct Answer

A. Incorrect: A join would return customer data and sales order data where the customer was associated with a sales order.
B. Incorrect: An outer join would return customer data and sales order data regardless of an association between them.
C. Incorrect: An exists join would return customer data for customers who are associated with a sales order.
D. Correct: A notExists join would return customer data for customers who are not associated with a sales order.