I need some help to figure out how I can find out which records are being "dropped" when I do a SELECT * DISTINCT. I did a search for this and came up with some suggestions but they don't seem to fit this situation. One of the suggestions was:


SELECT COUNT(field1) AS NumberofDup, field2 FROM MyTable GROUP BY field1 INTO CURSOR tmp

That'd be great, but I'm doing a

SELECT * DISTINCT, not a distinct on only one field.