ADO left join sorting issue
 

Hello,

I'm using the following SQL statement to join 2 tables based on a common key

Sql = "SELECT * FROM " & rs1 & " AS T1 LEFT JOIN (SELECT DISTINCTROW * FROM " & rs2 & ") AS T2 ON T1." & CommomVar(1) & "=T2." & CommomVar(1)

It works fine but there are instances where the result is sorted by the common key rather than the original order in T1. Actually , I don't look for any sorting

I'm not able to figure out the logic as sometimes it work fine (no sorting)

Any idea?

Thanks
Avi