Table Query

Mar 3 2010 10:21 PM
I need to query a table to return a unique set of "sets".  The table is structured as follows:
DetailID   HeaderID  SetID   ShiftID   Amount

DetailID is the primary key and HeaderID is a foreign key related to the Header Table.  The ShiftID is a foreign key to the Shift table.  The HeaderID will generally have multiple SetID's.  When the ShiftIDs and Amounts are the same with a different SetID I would like to return only one of the SetIDs and the related ShiftIDs and Amounts.  As an example:

Header Set Shift Amount
973 1 171 10
973 1 138 2
973 1 157 19
973 1 123 13
973 1 172 5
973 1 153 2
973 1 163 5
973 2 171 9
973 2 138 13
973 2 166 6
973 2 157 12
973 2 143 12
973 2 123 2
973 2 153 1
973 2 168 1
973 3 171 9
973 3 138 13
973 3 166 6
973 3 157 12
973 3 143 12
973 3 123 2
973 3 153 1
973 3 168 1

Sets 2 and 3 are identical so I would like to only return sets 1 and 2 or sets 1 and 3 with the table headers showing.

Thank you

Answers (3)