title: How to left join Excel table to a table in SQL Server database
body: <p>I have a table (<code>tbl1</code>) in an Excel file with about 70k rows. I have linked that table into Power Pivot. There is another table (<code>tbl2</code>) in SQL Server with millions of rows that I need to left join to the table in my Excel file on </p>
  
  <pre><code>tbl1.[Member Number] = tbl2.[memid]
  </code></pre>
  
  <p>What query should I use to do it without having to import the whole <code>tbl2</code> from SQL Server (throws error on Power Pivot due to memory constraints)? </p>
  
  <p>Preferred environment is Power Pivot, but I do have SQL Sever Management Studio. I don't have WRITE permission in the server where <code>tbl2</code> is located. I do however have WRITE access in a different server.</p>
  
  <p>Thank you!</p>