On 5/9/05, Jonathan Dillon <jdillon at boehm-ritter.com> wrote: > SELECT DISTINCT(email), firstname, lastname, phone FROM tablename; > > This is rather retarded, but why would this pull up duplicate emails? I > just don't understand. I thought DISTINCT would explicitly be distinct to > the column name. What is it to do with the following data? joe at blow.com Joe Blow 555-555-5555 joe at blow.com Joe Blow 555-555-5556 What row is it supposed to return? The reality is that every unique *combination* of fields listed after the DISTINCT keyword will be returned. -- Matt Warden Miami University Oxford, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.