How to combine two tables with multiple reference fields?
I was wondering on how you would solve this issue... We have two tables which we would like to left join but avoid Sync error key.
We are trying to left join them on "Refnr" but as there are no further rules, the data just explodes. This is because adds the ID on all refnr but we only want data to be joined where applicable. Please see Current Result and Ideal Result.
Hopefully you guys can help on what the best approach would be, thanks in advance.
We have two tables with the following information: