Re: Render row without duplicates

[Gary Smith]

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