They produce the same output, but they can procude different execution plans, depending on the engine and the query itself (ok, not the query above). But sorry for putting both in the same query...Xmas79 - why did you suggest DISTINCT and GROUP BY in the same query?
They bsically produce the same output - right?....
And sorry for answering late too... VBForums mail just arrived a few minutes ago...
Best regards,
Xmas.




....
Reply With Quote