title: Connection to two (or more) sharepoint lists with ADODB
body: <p>I can connect to a SharePoint list with ADODB this way :</p>
  
  <pre><code>Dim objCon As New ADODB.Connection
  objCon.Open "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=mysite/documents;LIST={xxxx-guid-xxxx};"
  
  Dim rst As Recordset
  Set rst = objCon.Execute("Select * from list1)
  </code></pre>
  
  <p>and it's working :).</p>
  
  <p>Now, I would like to connect two list at the same time to do an inner join :</p>
  
  <pre><code>Set rst = objCon.Execute("Select * from list1 inner join list2)
  </code></pre>
  
  <p>but I don't find the syntax to put the second list GUID on the connection string. How can I do ?</p>