ADO left join count matches

Discussion in 'Excel Programming' started by metricsinstitute@gmail.com, May 13, 2014.

  1. Guest

    Hello,

    I'm using

    Sql = "SELECT * FROM " & rs1 & " AS T1 LEFT JOIN (SELECT DISTINCTROW * FROM " & rs2 & ") AS T2 ON T1." & CommomVar & "=T2." & CommomVar
    objRecordset.Open Sql, ObjConnection, adOpenForwardOnly

    to match between 2 recordsets and it works well

    How can I get the number of matches a record from T1 that has a counterpart in T2?

    Thanks
    Avi
     
    , May 13, 2014
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.