Distinct values of a combination of two fields 1

[laina222]

This is probably an easy one, I've just never done it before...

In my table, I have two fields for which I want to find distinct values for a combination of the two fields. I also want to include other fields in my results as part of the SELECT statement.

Any ideas? Thanks for any help in advance

 

[Golom]

The General approach is

Select Fld1, Fld2, XX(Fld3), XX(Fld4), ...

From tbl

Group By Fld1, Fld2

Where "XX" is an aggregate function that specifies which of the values in the other fields that you want to see. It may be FIRST, LAST, MIN, MAX, SUM, AVG and may be different for each of the fields.

 

[laina222]

Thanks for your help! I've finally got it figured out...