Re: [sqlite] Getting a Unique column from a query

[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 c

Re: [sqlite] Getting a Unique column from a query

It would be ok to have duplicates of school_id. I just want to make sure that new_id is unique. Jay Sprenkle <[EMAIL PROTECTED]

Re: [sqlite] Getting a Unique column from a query

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.teacherI