Yeah, I know about the criteria.setDistinct()... However, that only sets the distinct on the primary key. This is a non-primary key value. Is there any other way?
Thanks. ------------------------------------------------------------- Darin Wilcox Web Engineer College of Nursing University of Utah 585-7332 >>> [EMAIL PROTECTED] 06/06/02 11:25AM >>> criteria.setDistinct(); -----Original Message----- From: Darin Wilcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 06, 2002 12:24 PM To: [EMAIL PROTECTED] Subject: Select statement with distinct All, Forgive me if I have missed something in the archives, but I can't seem to find a solution to this problem... I am using tdk 2.1 and Oracle 8i. I have a select statement that looks like this: select distinct name from employee; However, name is not the primary key. Is there a way to get the distinct in there and make it work correctly? Thanks, - Darin ------------------------------------------------------------- Darin Wilcox Web Engineer College of Nursing University of Utah 585-7332 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
