Different joins in X++ (Inner ,outer ,exist, not exist)

Take 2 tables A & B.

Table A :

Name        Num

Atul             1

Anju            2

Amit            3

Akshay        4

Ritu             5

Table B :

Class        Department        Num

first           accounts            1

second      HR                     2

third          Finance             3

fourth        Technical          4

Fifth          Solution            4

1. Inner join: The common records of both the tables

2. Outer join: All records of table A and common records of Table B

3. Exist join: common records from Table A

4. Not Exist join: The not common record of Table A

Reference