List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:January 2 2010 6:08pm
Subject:Re: Render row without duplicates
View as plain text  
Hi First i want to thanks to my mysql groups,

Sorry , just now i find time to see mail,

Am not sure, but i guess this union solves my problem,

But let me check it, give me a time..plz

On Sat, Jan 2, 2010 at 7:24 PM, Jim Lyons <jlyons4435@stripped> wrote:

> Your table structure makes the SQL a little inelegant, but I'd say this
> would give you what you seem to want:
>
> select Hospital1Code  from tab where Hospital1Code   is not null
> union
> select Hospital2Code  from tab where Hospital2Code   is not null
> union
> select Hospital3Code  from tab where Hospital3Code   is not null
>
> The "union" will eliminate duplicates.  Maybe this would be better
>
> select * from (
>      select Hospital1Code  from tab where Hospital1Code   is not null
>      union
>      select Hospital2Code  from tab where Hospital2Code   is not null
>      union
>      select Hospital3Code  from tab where Hospital3Code   is not null
> ) A order by 1
>
> Jim
>
>
>
>
>
>
>
> On Sat, Jan 2, 2010 at 6:43 AM, bharani kumar <
> bharanikumariyerphp@stripped> wrote:
>
>> Hi
>>
>> My fields something like
>>
>> hospital1,hospital2,hospital3,patientname,
>>
>>
>> Exact table look like
>>
>> PatientName  Hospital1Code  Hospital2Code  Hospital3Code
>>
>> Bharani           1234                NULL                 NULL
>>
>> Kumar             5678                1234                 NULL
>>
>> Senthil            9632                 5675                8524
>>
>> John               1234                  4567               8524
>>
>>
>> Can u tell me the query which return output like ,
>>
>>
>> HospitalID
>>
>> 1234
>> 5678
>> 9632
>> 5675
>> 8524
>> 4567
>> 8524
>>
>> Constraint are
>>
>> 1. No Duplicate records,
>> 2.One single column as Output Result ,
>>
>>
>>
>> This query purpose is , i have around 1000 patients in my DB,
>>
>> Each patient may have one,two,three hospital code,that's y the field are
>> hospital1,hosptial2,hospital3,
>>
>>
>> i know , i can display all hospital code with unique , but i dont in the
>> single column , with unique record,
>>
>> Can you tell me how to do this ?
>>
>>
>> Thanks
>>
>
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>



-- 
Regards
B.S.Bharanikumar
http://php-mysql-jquery.blogspot.com/

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