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    • Learning MySQL  Getting Started  

SQL file Code GIST: https://gist.github.com/prof3ssorSt3v...