What query can I run to show me all entries in my table that are not distinct for one field? Then, how do I make it to only include 1 entry for each?
.. fROM Table?<BR><BR>
I know how to only get DISTINCT, but what I want to know is how to actually find the duplicates so I can get them out!
.. [eom] on the title. Saves us a click on the link.<BR><BR>Just FYI.<BR><BR>;-)
sorry, it told me I had to fill something in. Haven't slept so I am not on my toes. Sorry to waste anyone's time.
.. just a FYI about ettiquette.<BR><BR>Generally, if I have nothing to say in the post, I just put a period. It's more about putting the "eom" into the title to save me from having to click on the message.