title: DQL Query fails
body: <p>I've got 2 tables in an MySQL DB, im using doctrine 1.2 and symfony 1.4.4</p>
  
  <p>Installedbase and Spare</p>
  
  <pre><code>Installedbase:
  ib_id
  app_id
  location
  </code></pre>
  
  <p>and</p>
  
  <pre><code>Spare:
  spare_id
  app_id
  amount
  </code></pre>
  
  <p>Now i want to join the to tables to show how many of the app are in the spare.</p>
  
  <p>e.g.</p>
  
  <pre><code>$q = self::createQuery("l")
  -&gt;select('i.*, s.*')
  -&gt;from('InstalledBase i, Spare s')
  -&gt;execute();
  
  return $q;
  </code></pre>
  
  <p>Doctrine knows there is a relation between the tables on the app_id field but i get the error </p>
  
  <pre><code>500 | Internal Server Error | Doctrine_Hydrator_Exception 
  "Spare" with an alias of "s" in your query does not reference the parent component it is related to.
  </code></pre>
  
  <p>yaml:
  <a href="http://pastey.net/137237" rel="noreferrer">http://pastey.net/137237</a>
  I cant figure this one out, does anybody know what doctrine is complaining about?</p>