>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

>
>Can you simplify the query, perhaps a simple distinct query, followed
>by another query based on the unique IDs retrieved in the first?
>

You'll have to excuse my ignorance but I'm not sure I follow.  Are you talking about grabbing the primary keys?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to