List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:January 2 2010 12:51pm
Subject:Re: Render row without duplicates
View as plain text  
Benedikt Schackenberg wrote:
> Am 02.01.2010 13:43, schrieb bharani kumar:
>> No Duplicate records,
>>    
> select hospital1code from *yourtable* grop by hospital1
>
This won't work as he's also looking for entities in the hospital2code 
and hospital3code fields to be returned in the same resultset, but as a 
single column. Essentially, hospital1code, hospital2code and 
hospital3code need to be merged to a single column, deduped, and then 
returned.

Gary
Thread
Render row without duplicatesbharani kumar2 Jan
  • Re: Render row without duplicatesBenedikt Schackenberg2 Jan
    • Re: Render row without duplicatesGary Smith2 Jan
  • Re: Render row without duplicatesGary Smith2 Jan
  • Re: Render row without duplicatesJim Lyons2 Jan
    • Re: Render row without duplicatesbharani kumar2 Jan
      • Re: Render row without duplicatesbharani kumar3 Jan
        • Re: Render row without duplicatesJim Lyons3 Jan
          • Re: Render row without duplicatesbharani kumar15 Jan