MySQL Join each row to every row except itself
<p>I have a single table that I need to join to itself but each entry needs to be joined to every entry in the table except to itself.</p>

<p>Example:</p>

<pre><code>my_table
 tableId  name
 1        John
 2        Dave
 3        Bob
</code></pre>

<p>Output from join:</p>

<pre><code> tableIdA nameA tableIdB nameB
 1        John  2        Dave
 1        John  3        Bob
 2        Dave  1        John
 2        Dave  3        Bob
 3        Bob   1        John
 3        Bob   2        Dave
</code></pre>

<p>How would I achieve such an output?</p>