>
>I also tried the approach as you proposed by adding all fields, it doesn't work. Then, I added a GROUP BY 1,2,3,4... It doesn't work either. As for now, I really can't find a way to make that work. But, I assume Sergey is coming up with an answer. :)
When you say GROUP BY 1,2,3,4... doesn't work, do you mean that you get an error or result of the query isn't what you want?
--sb--