Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8 Field9
cat dog ... ... ... ... ... ... ...
cat mouse
fish goat
cat dog
If I say SELECT FOO.*, I will get 4 records. However, I do not want duplicates of field1+field2. I do not care which record I get.