title: dplyr sql joins
body: <p>Consider the following SQL:</p>
  
  <pre><code>    SELECT D.product_name
        FROM business.payment P
   LEFT JOIN dim.product_name D 
          ON D.product_id = P.product_id
  </code></pre>
  
  <p>The query returns the list of product_names that are in the payment table and does so based on a join.</p>
  
  <p>How would something like this be replicated in dplyr without pulling into memory? I'm working with a database connection.</p>
  
  <p>I tried the following, but to no avail: </p>
  
  <pre><code>product_name &lt;- 
    business %&gt;% 
    tbl('dim_product') 
  
  business %&gt;% 
    tbl('payment') %&gt;% 
    left_join(product_name, by = 'product_id') %&gt;% 
    select(product_name) %&gt;% 
    collect()
  </code></pre>
  
  <p>I've searched quite a big and no one seems to have addressed this.</p>
  
  <p>Thanks!</p>