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

Reply via email to