title: Ambiguous column in MySQL/Rails find method
body: <p>I'm getting this error</p>
  
  <blockquote>
    <p>Mysql::Error: Column 'id' in field list is ambiguous</p>
  </blockquote>
  
  <p>when using a find method like such: <code>self.prompts.find(:all, :select =&gt; 'id')</code></p>
  
  <p>The models are being called using a has_many :through association, so MySQL complains that there are multiple 'id' columns, since all 3 tables being used have an 'id' column.</p>
  
  <p>I looked this up and understand what is going wrong on the SQL end, but don't know how to resolve it in the ActiveRecord find method, and I'm not confident in my SQL abilities to try rolling my own SQL query. Is there a way to massage the find method into something that'll play well?</p>
  
  <p><em>edit</em></p>
  
  <p>Here is the relevant Actor model code:</p>
  
  <pre><code>class Actor &lt; ActiveRecord::Base
    has_many :acts, :dependent =&gt; :destroy
    has_many :decisions, :through =&gt; :acts, :order =&gt; 'created_at'
    has_many :prompts, :through =&gt; :decisions, :order =&gt; 'id'
  </code></pre>