> >You realize that a distinct causes every record in every table
> >(referenced in the query) to be examined, and the specified fields
> >compared to assure uniqueness.
>
> No, I didn't realize that.��Thanks for the insight though!
>
> >
> >What db server are you using?
>
> Acess
>
>
Thought so -- some of your field names look like they are text or memo
fields.
Some dbs will not allow distinct on text or memo fields, because this
changes an already inefficient operation to become exponentially more
inefficient.
Dick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
