Hi Yossi,
SELECT DISTINCT Field1, Field2 FROM FOO
SELECT Field1, Field2 FROM FOO GROUP BY Field1, Field2
MartinaJ
>Hi All:
>
>Consider the following table, FOO.
>
>
>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.
>
>SELE DISTINCT will not work, since there may be differences in the other fields.
>
>Thanks,
>
>Yossi