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

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.
Similar Threads
  1. Derek Richards

    Problems from ADO Ext. 2.6 vs. ADO Ext. 2.5

    Derek Richards, Jan 27, 2004, in forum: Excel Programming
    Replies:
    2
    Views:
    262
    Derek
    Jan 27, 2004
  2. Karla
    Replies:
    1
    Views:
    132
    Jamie Collins
    Jun 22, 2004
  3. ExcelMan

    ADO Recordset Problem -- Left Join

    ExcelMan, Jan 23, 2005, in forum: Excel Programming
    Replies:
    4
    Views:
    115
    Rob van Gelder
    Jan 24, 2005
  4. Paul Black

    Count Numerous Matches Only Once

    Paul Black, Oct 13, 2005, in forum: Excel Programming
    Replies:
    2
    Views:
    113
    Paul Black
    Oct 14, 2005
  5. ADMIN
    Replies:
    0
    Views:
    123
    ADMIN
    May 29, 2006
  6. DaveO

    ADO; RELATE vs JOIN.

    DaveO, Jul 13, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    155
    Tom Ogilvy
    Jul 13, 2006
  7. Replies:
    3
    Views:
    95
    Bob Phillips
    Nov 6, 2006
  8. Oscar K

    SQL + INNER JOIN + ADO

    Oscar K, Jun 5, 2008, in forum: Excel Programming
    Replies:
    0
    Views:
    76
    Oscar K
    Jun 5, 2008
Loading...