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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
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:
    235
    Derek
    Jan 27, 2004
  2. Karla
    Replies:
    1
    Views:
    115
    Jamie Collins
    Jun 22, 2004
  3. ExcelMan

    ADO Recordset Problem -- Left Join

    ExcelMan, Jan 23, 2005, in forum: Excel Programming
    Replies:
    4
    Views:
    95
    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:
    99
    Paul Black
    Oct 14, 2005
  5. ADMIN
    Replies:
    0
    Views:
    100
    ADMIN
    May 29, 2006
  6. DaveO

    ADO; RELATE vs JOIN.

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

    SQL + INNER JOIN + ADO

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