title: Understanding SQL Aliases
body: <p>I understand the concept of SQL aliases, but in the following doctrine query language example, the alias is at the front of the table names, as well as following behind them. Could someone help explain whats happening in this query? I want to try to get a better understanding of whats happening before i attempt to alter it.</p>
  
  <pre><code>public function getByDomain($domain)
    {
      return $this-&gt;createQuery('d')-&gt;select('d.*, c.*, p.*, cl.*')
              -&gt;innerJoin('d.Table1 c')
              -&gt;innerJoin('c.Table2 p')-&gt;innerJoin('c.Table3 cl')
              -&gt;where('d.name=?',$domain)-&gt;fetchOne();
    }
  </code></pre>