Join on a Field that May or May Not be Unique

Using the output from our last Join Query we can see that these 2 fields seem to have similar contents, hence an “=” operation could be attempted

Here are the results, So it returns an output, but is the output useful?

So SQL will let you write non-logical Queries