Microsoft
MB6-704 · Question #39
You are developing X++ code to retrieve data from a table named Tablel. You need to use a select statement to retrieve only records from Tablel that have related records in a table named Table2…
Sign in or unlock MB6-704 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Develop X++ code
Question
You are developing X++ code to retrieve data from a table named Tablel. You need to use a select statement to retrieve only records from Tablel that have related records in a table named Table2. Which type of join should you use?
Options
- AInner
- BExists
- COuter
- DNot exists
Unlock MB6-704 to see the answer
You've previewed enough free MB6-704 questions. Unlock MB6-704 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#join types#inner join#exists join#select statement