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 |
All times are GMT +1. The time now is 10:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com