DUPLICATE ROWS WHEN YOU JOIN 2 QUERIES ON TABLES IMPORTED FROM SQL SERVER

[Syndicate_Admin]

When I do join query of 2 tables imported from SQL I duplicate the records of the first one and I distort the model.
You would supposedly have to keep all the rows of the first and the matching values of the second (without duplicating those of the first). The combination is made by a unique record ID.

[Syndicate_Admin]

This helped me fix the duplication of lines, "add in maximum number of matches" =1

[Syndicate_Admin]

it happens to me the same, could you solve ?

[v-xulin-mstf]

Hi @Syndicate_Admin,

Depend on your need, you can try Right outer join.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[amitchandak]

@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Syndicate_Admin]

Hello.
yes, right.

The table on the Left is incremental (each day only the new ID_EXP are added.)
The table on the right contains the closing date of these files and has been updated in full every day (they are bank debtors' files).
When I try to combine queries (using the ID_EXP field) to bring the close date to the table on the left, I duplicate or triple the rows in the table on the left.

I use "combine queries" and this option that I understand is a like a LEFT JOIN:

Thanks a lot!! 🙂