Thanks again!

I'll try to explain to the girls that I'll find tonight the diffrence between GROUP BY AND DISTINCT, but I guess that I'll have to make them drink so they'd understand something...

have a nice weekend!

"Michel Walsh" a écrit dans le message de news: ...
and here is the query plan, again, the same, for both statements (excuse the HTML format, I suspect that without it, it turns out un-readable):

|--Sort(DISTINCT ORDER BY[pubs].[dbo].[authors].[au_fname] ASC))

|--Index Scan(OBJECT[pubs].[dbo].[authors].[aunmind]))




Vanderghast, Access MVP