title: Joining 3 tables with 2 being SELECT *
body: <p>I am doing research with the test-retest. I have three tables. One table is for Demographics and I only need a limited amount of data from it. The other two tables each have 235 fields the only difference being the table name. I've tried statements like:</p>
  
  <pre><code>SELECT * FROM research_statement_answers, statement_answers, demographic_answers
  WHERE (( research_statement_answers.id_Questions = demographic_answers.id_Demographic)
  and (statement_answers.id_Questions = demographic_answers.id_Demographic)
  and (demographic_answers.Research_Completed = 1))
  </code></pre>
  
  <p>But that does not work. All examples I've seen would require me to name all 235 fields in both tables. I can do that, but I cannot believe that's the best way to proceed. Suggestions are therefore most welcomed. Thank you. Rick</p>