>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
Select * From table1 Group By field1,field2,field3 && but don't include field_x in Group by clause
Edward Pikman
Independent Consultant