When you want to retrieve data with a SELECT statement and that data come from multiple tables then you should always be using an INNER JOIN.
This video covers some best practices for working with INNER JOINs.

MySQL Tutorial – https://www.youtube.com/watch?v=a9W7OpS4LfI&list=PLyuRouwmQCjlXvBkTfGeDTq79r9_GoMt9

SQL file Code GIST: https://gist.github.com/prof3ssorSt3v3/6a4a696a52745987ce973fdb12e3260c