Can we keep duplicate record in Union

(0) Share

Report

Posted on by ShaqAX

709

Hello guys,

Some question about Union. I created a query which consist of 2 tables which are at the same level. This will make the query is UNION, right ?

Is there a setting to not remove duplicates ?

My 2nd question is actually, provided the fieldname is same, in the fields node when we put the field that we want to be included . display in that query, in the property we need to specify the data source, right ? when we 2 or more tables as the data source, which tables I should specified in that field's property ? Currently I put the 1st table, but for "documentation wise" it is kinda weird because obviously it is a Union query.. we want to get the fields from all tables (all data source)

Thanks,

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WillWU 22,361 on at

Like (1)

Report

Hi ShapAX,

You could choose Union to eliminate duplicate records. and choose UnionAll to include duplicate records.

Please read this document:docs.microsoft.com/.../how-to-combine-data-sources-in-a-union-query

Was this reply helpful? Yes No