Home » Microsoft » MB6-704 » Which type of join should you use?
You are developing X++ code to retrieve data from a table named Table l.
You need to use a select statement to retrieve only records from Table l that have related records in a table named Table2.
Which type of join should you use?
A. Inner
B. Exists
C. Outer
D. Not exists
Correct Answer: A
Explanation/Reference:
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.
Reference: Link Type and Join Types in ax 2012