View Single Post
  #1 (permalink)  
Old January 9th, 2005, 10:08 PM
sprion sprion is offline
Registered User
 
Join Date: Jan 2005
Location: Singapore, , .
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Distinct or Group By?

8403213D PTE John Mother 9123456
8403213D PTE John Father 9321323
8403213D PTE John Sister 9111111
8221234Z MSG Dick Spouse 8321345
8323157G BG Tom Daughter 9236579

These are the current results I'm getting..

How should I query to get this instead? ::

8403213D PTE John Mother 9123456
8221234Z MSG Dick Spouse 8321345
8323157G BG Tom Daughter 9236579

Thanks :P