| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO left join count matches
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL statement for left outer join for ranges in the same file | Excel Programming | |||
| Subquery after Left Join | Excel Programming | |||
| LEFT JOIN sql query | Excel Programming | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
| ADO Recordset Problem -- Left Join | Excel Programming | |||
Linear Mode
