Please advice.
The subset of data you’ve chosen to show does not allow one to draw any conclusions. Look for the things that are different in the joined result - the things that are identical are mostly uninteresting when trying to figure out what additional join conditions are needed so that only a single matching row is found.
Your other table doesn’t have a primary key defined. If you do that the answer will likely present itself to you.
David J.
