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