This type of join is you telling the database “You know what a Join is, so join these 2 tables”
MySQL (or really any SQL platform) is not AI
If the 2 tables in question both have 1 field with the same name (and only 1) then SQL can figure out the join
So to make sure this works I made a custom table of Star Trek Actors
The memberID field is doing the magic