title: How can i join records from 5 different tables?
body: <p>I want to retrieve all of the courses with their associated data. For example the categories the course is in and the tutor for the course. Can I do this in one Select statement using joins to retrieve the data I need?</p>
  
  <p>I have to following schema</p>
  
  <pre><code>tbl_courses (id, name, description, tutor_id, date)
  tbl_course_categories (id, course_id, category_id) 
  tbl_categories (id, name, parent_id)
  tbl_users (id, username, email, password)
  tbl_tutors (id, first name, last name, user_id)
  </code></pre>