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…

The correct answer is A. Inner. InnerJoin: - Combined data source select the record from the main table that matches records in the joined table and vice versa. There is one record for each match. Records without related records in the other data source are eliminated from the result.

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

How the community answered

(46 responses)

A
72% (33)
B
4% (2)
C
15% (7)
D
9% (4)

Explanation

InnerJoin: - Combined data source select the record from the main table that matches records in the joined table and vice versa. There is one record for each match. Records without related records in the other data source are eliminated from the result.

Topics

#join types#inner join#exists join#select statement

Community Discussion

No community discussion yet for this question.

Full MB6-704 Practice