Hello,

I'm using this SQL statement to left join 2 Excel ranges and it works fine

Code:
Sql = "SELECT * FROM " & rs1 & " AS T1 LEFT JOIN  " & rs2 & " AS T2 ON  T1." & CommomVar & "=T2." & CommomVar
I want the joining to refer to the distinct rows of T2. The statement
Code:
Sql = "SELECT * FROM " & rs1 & " AS T1 LEFT JOIN  " & rs2 & " AS DISTINCT T2 ON  T1." & CommomVar & "=T2." & CommomVar
returns an error

Any idea?

Thanks
Avi