Originally Posted by Old Pedant
FROM tablename AS t1, tablename AS t2
WHERE t1.lnktxt = t2.lnktxt
AND t1.cattxt = t2.cattxt
AND t1.datetxt < t2.datetxt
ALSO: If you happen to have 3 (or more!) records with the same lnktxt and cattxt values, that will delete *all* of them except the one with the latest datetxt field.
That works wonderfully! One final question on this mission....is there any way to modify it so if it runs across an instance where all 3 fields are the same, it can drop all but one?