Here's the scoop.
I own filetransit.com, a shareware site. Has approximately 3000 titles. I need to run a query that will show me duplicate entries, such as 2 Records with the same name, ie: software title.
The thing is I don't want to specify what the name is, I just want a query that will show me all records that have "atleast" 1 of the same field names.
Say there is a program called computer tester 5.1 (Version in another field)
Many times an author will submit a new version of their title without knowing they have an old version.
So now a company submitted computer tester 6.0
So now I got 5.1 and 6.0 in my database, and I don't know about it.
How can I get this fixed, If this can be done with one query it would be great, the field name is ft_name
Thank You
I own filetransit.com, a shareware site. Has approximately 3000 titles. I need to run a query that will show me duplicate entries, such as 2 Records with the same name, ie: software title.
The thing is I don't want to specify what the name is, I just want a query that will show me all records that have "atleast" 1 of the same field names.
Say there is a program called computer tester 5.1 (Version in another field)
Many times an author will submit a new version of their title without knowing they have an old version.
So now a company submitted computer tester 6.0
So now I got 5.1 and 6.0 in my database, and I don't know about it.
How can I get this fixed, If this can be done with one query it would be great, the field name is ft_name
Thank You