Forum Discussion

PierreL69's avatar
PierreL69
Helper IV
3 years ago
Solved

Merge two queries with the exact same column & without duplicate row

Hello community,
I am writing to you because I cannot do what I want, which seems simple to me
I want to join two queries or two tables that have exactly the same structure (same column), joined based on one column so that there is no duplication

 

So I want to use the merge function but the join Kind I need is not there, below is what is available

And what I want is  :

 

But I cannot find this joint type.

 

Edit: Sorry I did my message too quickly what un want to join is the red circle + the blue part

 

Someone have an idea ?

Thanks

 

 

3 Replies