Question about the right kind of join to use

Yes, I updated my query in the code. Thanks!