Different Joins in AX 2012

Today, I will demonstrate on different joins present in AX 2012.

I will provide the solution with simple example.

Firstly, I created two tables and give relation with these tables.

First Table

Join_a

Second Table

join_b

There is a normal relation between these tables as follows…

join_c

I created form with two datasources in it.

A) Inner Join between these tables.

join_d

As you can see, firsttable has one more record which is not shown as there is no linked record exist in secondtable because of inner join.

B) Outer join between these tables.

join_e

As you can see, firsttable has one more record which is shown because of outerjoin.

C) Exist Join between these tables.

join_f

As you can see, only fields from first table will be shown which are matched.

D) Not Exist Join between these tables.

join_g

As you can see, only fields from first table will be shown which are not matched.

Hope you understand, Happy DaXing……….

Advertisements

3 responses

  1. simple but awesome explaination. Thanks a lot 🙂

    Liked by 1 person

  2. why it will not shows corresponding dept for those which is existed in the form in exist and not exist join

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: