R Import Multiple Tables from database using sqlQuery
<p>I know how to import a table from the database, it works; but what if I have 6 tables, is there a better way to import from 6 different tables and create 6 different data.frames ?</p>

<p>Notes &lt;- sqlQuery(dbConnection, "
                      SELECT *
                      FROM
                      Table1")</p>

<p>??</p>