I have a table with two fields in it, Contact and RelatedContact.
The first two records look like this:
ID Contact RelatedContact
1 1000 7000
2 7000 1000
I need to have just one record in this table, doesn't matter which one. I can't have two records
in this table that are the reverse of each other. How can I eliminate one of them?