NO!!!! Setting Enginebehavior to 80 is the same as accepting that you may end up with the wrong data. Not a good solution!

>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