View Single Post
  #7 (permalink)  
Old September 29th, 2004, 06:42 AM
Anantsharma Anantsharma is offline
Friend of Wrox
 
Join Date: Sep 2004
Location: New Delhi, Dekhi, India.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Anantsharma Send a message via Yahoo to Anantsharma
Default

Well friend do you aware of it that SQL gets forced to sort the resultset on the colum for which Distinct is written? So as per your query, SQL will try to order the resultset always on first colum. Further ur query is a little bit complex to read. I will review later.





B. Anant