> hi,
>
> have a table with the following conceptual data...
> rec# col1 col2 ... coln
> 1 1 d data
> 2 1 m data
> 3 1 d data
> 4 2 d data
> 5 2 m data
> 6 3 d data
> 7 3 m data
> 8 3 d data
>
> trying to come up with a single query that would return unique records
> where the combination of col1 and col2 are unique. in the example,
> would want rec #1, #2, #3, #4, #6, and #7.
>
> have come up with a couple of multiple query ideas, but was wondering
> how to do this in a single query (if possible).
>
> TIA,
>
> Pete Turner
> Sun Nuclear Corp.

but #5 is unique too no?
Alan
try a view on ditinct col1, col2
then join the other data to the view
Alan