Join's in D365fo or AX2012

 Joins in X++

    In the X++ language, developers can write code that looks very similar to T-SQL code to retrieve data.

Join’s are 4- types,

                              >Inner join

                              >Outer join

                              >Exist join

                              > Not exist join

                              Inner join :  In the X++ language the word ‘inner’ is not written. This returns a row when there is a match in both tables.

                              Outer join :  This will return all rows from the left table, even if there is not a match in the right table.

                              Exist join :  exists join will return records from the first table, only if there exists a record in the second table.

                              Not Exist Join : This returns a row in the first table, if there does NOT exist a match in the second (or joined) table.