Microsoft Dynamics AX (Archived)

Advantage of Union query.

(0) Share

Report

Posted on by @rp@n

Dear All,

Can you please give me an example of Union query in Dynamics AX 2012 R3.

what is the advantage of Union query?

How to write X++ code with using Union query.

Please give me an example.

Please give me more shed on this.

Thanks!

Arpan

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (5)

Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can not use union in x++ but you can use it in Query from AOT

union is useful to combine multiple datasources

msdn.microsoft.com/.../cc605991.aspx

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Hakim

Can you please let me know when we use exactly Union query?

Please give me more shed on this.

Thanks!

Arpan

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

in general, if you write two complex query in sql , you can union this quires.

so we use union based on your requirements

if it is difficult to return your data by one query in sql . you can create two quires and use union

as the same in AOT you can create multiple datasources and use union

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Union query is useful if we want to have several datasources of same table or type on the query.

Refer this link:

(Union queries)

community.dynamics.com/.../union-queries

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Chaitanya

Sorry not understand "if we want to have several datasources of same table or type on the query".

Please give me an example.

Please give me more shed on this.

Thanks!

Arpan

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (1)

Report

Hi,

If you check the example in the suggested link, it has two datasources of type inventtable at different stages with different ranges. It has two options with Union and UnionAll.

where Union removes duplicated records and UnionAll keeps duplicated records.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

please go on w3 schools for basics. that could be best source as start for these concepts

www.w3schools.com/.../sql_union.asp

once you will have knowledge of UNION and UnionAll, I can see next question should be as following

Difference between Union and Full Outer join. You can search and read this as well.

Was this reply helpful? Yes No
Verified answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

yes, Chaitanya is correct

we can use it to remove duplication

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

Thanks Chaitanya and Hakim

Was this reply helpful? Yes No