Could you please enrich your question and give some more details? Like current input, expected output, (anonymized) source files, a workflow showing the problem. Theoretically, a left outer join will join multiple values if the right table contains more than matche, but the most efficient solution really depends on what you have in terms of data and are expecting as output.
The more you can provide, the better people will be able to help you out