Microsoft
70-779 · Question #13
You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new table that has the…
The correct answer is B. Left Outer. See the full explanation below for the reasoning.
Question
You have two queries named Client and Invoices. A sample of Client is shown in the following table. A sample of Invoices is shown in the following table. You need to create a new table that has the following information. Which join kind should you use?
Exhibits
Options
- AInner
- BLeft Outer
- CRight Anti
- DLeft Anti
How the community answered
(32 responses)- A6% (2)
- B78% (25)
- C13% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.

