title: MySQL SQL Query Question from tutorial
body: <p>I am reading a tutorial, and I just wanted to make sure it was being written correct for my own understanding.</p>
  
  <pre><code>SELECT Division.id FROM items AS Item
  LEFT JOIN categories AS Category ON Category.id = Item.category_id
  LEFT JOIN sections AS Section ON Section.id = Category.section_id
  LEFT JOIN divisions AS Division ON Division.id = Section.divison_id
  WHERE Item.id = $id
  </code></pre>
  
  <p>For some reason, the first line <strong>Division.id</strong> does not make much sense because the <strong>items</strong> table is not the <strong>divisions</strong> table, so how could the <strong>Divisions.id</strong> be FROM <strong>items</strong>?</p>
  
  <p>My guess is this line: <strong>LEFT JOIN divisions AS Division ON Division.id = Section.divison_id</strong> sets <strong>Division.id</strong> (in the first line of the query), so this would look for all <strong>Item.id</strong> that equal the <strong>Division.id</strong>????</p>
  
  <p>I know this is probably dumb simple, but any ideas would be great. I have the idea I am not understanding something here. If anyone can set me straight would be much appreciated.</p>