Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADO left join count matches | Excel Programming | |||
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 | |||
ADO Recordset Problem -- Left Join | Excel Programming |