Martina,
I want all the fields in the result. Your options only give me field1 and field2.
I coull SET the ENGINEBEHAVIOUR to 80. This will allow it. However, I am looking for an elegant solution in 9.0.
Yossi
>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