title: How to select a specific field additionally to a tables default fields?
body: <p>I an looking to use a JOIN to select data from a table and a view in CakePHP like so :</p>
  
  <pre><code>$this-&gt;Annonces-&gt;find('all')
          -&gt;where($arrFiltres)
          -&gt;order($arrOrder)
          -&gt;join([
              'table' =&gt; 'annonces_suivis',
              'alias' =&gt; 'AnnoncesSuivis',
              'conditions' =&gt; [...],      
          ]);
  </code></pre>
  
  <p>And would like to be able to select all the fields from the first table and som of the jointed table like so :</p>
  
  <pre><code>-&gt;select(['Annonces.*', 'AnnoncesSuivis.id']);
  </code></pre>
  
  <p>But this creates a faulty SQL query.</p>