Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
<p>I get the following notification in phpMyadmin</p>

<blockquote>
  <p>Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.</p>
</blockquote>

<p>Below is the query I ran in phpMyadmin. I have tried using on instead of Using and I have also tried removing some of the joins. The minute I uses INNER JOIN I get the notification. </p>

<p>I have tried to find solutions but they all involve setting an index or AI for a column</p>

<pre><code>SELECT    mr.response_id, mr.user_id, mr.topic_id, mr.response,
                mt.name AS topic_name, mt.category_id,
                mu.username, mc.name AS category_name
     FROM       mismatch_response AS mr
     INNER JOIN mismatch_topic AS mt USING(topic_id)
     INNER JOIN mismatch_user AS mu USING(user_id)
     INNER JOIN mismatch_category AS mc USING(category_id)
</code></pre>

<p>but in all tables I have a column that is set as the primary key with Auto increment.</p>

<p>Not sure what else to do</p>