On Monday, November 13, 2023, Anthony Apollis <
anthony.apollis@gmail.com> wrote:
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.