title: R: Using sqldf and insert to create a dataframe
body: <p>I am trying to create a dataframe using sqlf and sql insert.  Here's a simple version of my code</p>
  
  <pre><code>d2 = data.frame(x=runif(10))
  sqldf(c("create table d1(min_x real, max_x real)", 
          "insert into d1 select min(x), max(x) from d2", 
          "select * from d1"))
  </code></pre>
  
  <p>The output is </p>
  
  <pre><code>       min_x     max_x
  1 0.05290026 0.9427019
  </code></pre>
  
  <p>Now I want to use d1 in my R code, but if I enter</p>
  
  <pre><code>d1
  </code></pre>
  
  <p>R responds</p>
  
  <pre><code>&gt; d1
  Error: object 'd1' not found
  </code></pre>
  
  <p>I have tried this using SQLite and RH2 with the same results.</p>
  
  <p>How do I use d1 in R?</p>