This will show you the manifests that are duplicated (e.g thatshow up more than once). Then it's easy to traverse the set and delete the extra records.
SELECT Manifest, COUNT(*) as Knt ;
FROM ManifestTable ;
GROUPBY Manifest ;
HAVING Knt > 1
>I want to delete all the records in a table that have the same manifest number but keep the one record of it in the table. How would I do this? > >Tyler
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry