ADO left join count matches

M

metricsinstitute

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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Minus/Intersect? 3
ADO Recordset Problem -- Left Join 4
SQL string problem 15
Unmatched query 3
Is there a way to release the memory taken by a Recordset Object ? 1
MS Access 0 Select from multiple tables using Left Join in query 0
SQL query to select rows with highest vales 2
join two databases in a query 3

Top