Warning: #1292 Truncated incorrect DOUBLE value: 'xxx' : <p>I'm trying to create a MySQL query to select two teams</p>

<p>Using the query below I keep getting this error and its not something I've come across before, google seems to offer a variety of answers but I'm unable to relate the fix to my query.</p>

<pre><code>SELECT 
        m.idm,
        m.buteq1,
        m.buteq2,
        tf.eq_name,
        ts.eq_name  
        FROM wpap_match  m
             INNER JOIN wpap_equipes tf
                on tf.eq_name = tf.id
             INNER JOIN wpap_equipes ts
                on ts.eq_name = ts.id
</code></pre>

<p>Result:</p>

<pre><code> Warning: #1292 Truncated incorrect DOUBLE value: 'ESS'
</code></pre>

<p>Can any one help to fix this ?</p>
