Programming help with a join

[SP01]

Hello All,

Trying to figure how to achieve the following. Appreciate your help on this.

I have two datasets A and B to join:

Dataset A has ID                          Dataset B has ID

ID                                                 ID

1                                                   1

1                                                   1

1                                                   1

1                                                   1

                                                     1

                                                     1

What I am trying to do is that I need them to merge and give me 4 rows of ID = 1 and also bring those extra 2 rows of ID = 1 into the final dataset.

What I want is the following:

Data want;

ID

1

1

1

1

1

1

Thank you for your help.

[Kurt_Bremser · Accepted solution]

A simple MERGE with BY ID will do it.