title: Joining several tables: table specified more than once error
body: <p>I am attempting to call data after joining all of my tables in a postgreSQL query. 
  I am getting the following error:</p>
  
  <pre><code>Error in postgresqlExecStatement(conn, statement, ...) : 
    RS-DBI driver: (could not Retrieve the result : ERROR:  table name "place" specified more than once
  )
  Failed to execute SQL chunk
  </code></pre>
  
  <p><em>After referring to similar posts and online resources</em>, I have attempted setting aliases (which only create new errors about not referring to the other tables in the FROM clause), reordering the table names (the cleanest, reordered chunk is posted below), and experimenting with UPDATE/FROM/JOIN as an alternative to SELECT/FROM/JOIN. However, I think I ultimately need to be using the SELECT clause. </p>
  
  <pre><code>SELECT *
  FROM place
  
  INNER JOIN place ON place.key = form.key
  INNER JOIN form ON form.id = items.formid
  INNER JOIN items ON items.recid = rec.id
  INNER JOIN rec ON rec.id = sub.recid
  INNER JOIN sub ON sub.id = type.subid
  INNER JOIN type ON type.name = det.typeid;
  </code></pre>