SELECT DISTINCT will give you unique occurances of all the items in your select list.  Suppose you
have a table with the following three records:

PatientID     PatientName     ICD9Description

0001          Barney          Goute
0001          Barney          Ulcer
0001          Barney          Purple Skin

SELECT DISTINCT PatientID, PatientName, ICD9Description will return all three rows, because the
value of the third field for each record is different, making the combination of the three fields
distinct.  Conceptually, how would you handle the different values of ICD9Description with just
one record?  If you could show us what you would like the output to look like in this example, we
can help you write the SQL to get there.

Kelly Rowe


---
You are currently subscribed to sql_language as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-sql_language-$subst('Recip.MemberIDChar')@p2p.wrox.com