Hi all,

I have a table where I need to retrieve all of the fields of the unique records, however _exclude_ one of the fields from consideration of unique while _including_ that field in the ouput.

In other words, while I _do_ want that field (call it field_x) displayed in the output, I do _not_ want that field used as part of the criteria for selection (i.e., select * distinct will not work).

I'm hoping for a relatively painless way to do this through a sql statement.

tia,

marc