title: inner join with COUNT() and GROUP BY
body: <p>I am using phpMyAdmin to test this query but keep getting a syntax error. I've tried looking it up in the MySql manual and trying other syntactical possibilities but I've gotten older in this process. Thanks for your help</p>
  <p>SELECT image_title, image_id, COUNT(other_sales.*) FROM art
  INNER JOIN other_sales ON (art.image_id=other_sales.image_id)
  GROUP BY (other_sales.image_id);</p>
  <p>MySQL said: Documentation</p>
  <h1>Documentation</h1>
  <h1>1052 - Column 'image_id' in field list is ambiguous</h1>
  <p>Ultimately, I want to count the number of times a specific number (image_id) occurs in the 'other_sales' table</p>