Won't you get duplicates rows of school_id, 2 when classtype = 2? On 9/30/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > is it possible to use a Distinct or Unique on a column such as: > > SELECT school.schoolID AS ID, > CASE WHEN class.classtype= 2 THEN class.classtype ELSE teacher.teacherID > END AS unique(new_id) FROM Region > > > SELECT school.schoolID AS ID, > CASE WHEN class.classtype= 2 THEN class.classtype ELSE teacher.teacherID > END AS distinct(new_id) FROM Region > > > I do not want any duplicates of the new_id. > > Thanks! > Nicole Hinderman > >
-- --- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264
