title: zend framework 2 - tablegateway join, where clause is ambiguous
body: <p>I would like to join many tables by tablegateway. It works fine but when I join some table with the same column name Zend throw error like that: </p>
  
  <pre><code>SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id_club' in where clause is ambiguous
  </code></pre>
  
  <p>my code looks like this:</p>
  
  <pre><code>    $id = $pId_club;
      $result = $this-&gt;tableGateway-&gt;select(function(Select $select) use ($id){
          $select-&gt;join('vm_position', 'id_position = vm_position.id', array('name'))
                 -&gt;join('vm_club', 'id_club = vm_club.id', array('club_name'))
                 -&gt;join('vm_user', 'id_user = vm_user.id', array('login'))
                 -&gt;join('vm_squad', 'id_club = vm_squad.id_club', array())
                 -&gt;where(array('id_club' =&gt; $id))
                 -&gt;order('id_user ASC');
      });
      $row = $result-&gt;current();
      return $row;
  </code></pre>
  
  <p>I have column <code>id_club</code> in the main table - <code>'vm_match'</code> and in <code>'vm_squad'</code>. Without joining <code>'vm_squad'</code> it works well.</p>