From: bharani kumar (bharanikumariyerphpgmail.com)
Date: Sat Jan 02 2010 - 06:43:46 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]