Wednesday, September 2, 2015

Joins in D365 F&O

Inner Join in X++
Ø  Select records from first table that have matching record with join table.
Ø  First table record and join table records are joined together  and show as single record.
Ø Records without related records in the jointable are eliminated from the result

Outer Join  in X++
Ø Select all the records from first table and related records from join table       
Ø The records are retrieved whether they have matching records in the joined table  
Ø If there is no match, the field from join table is empty 

Exist Join in X++
Ø Selecting record from first table only if there is matching record in join table.     
Ø It will return only one table record, not a related table record 

 NotExist Join in X++
Ø Select records from the first table that do not have a match in the joined table