can I do this in sql

From: Bob <bookouri_at_my-deja.com>
Date: Thu, 21 Oct 1999 14:55:40 GMT
Message-ID: <7un9h9$4e2$1@nnrp1.deja.com>

For some reason our database has race, hgt, wgt, hair color, eye color in a "profile" table. I need a view that gives me all that information on each individual on one row.

I can select all the data i need with:
select id,

   decode(off_prof.profile_type,'HEIGHT',off_prof.profile_code)height,
   decode(off_prof.profile_type,'WEIGHT',off_prof.profile_code)weight,
   decode(off_prof.profile_type,'HAIR_COLOR',off_prof.profile_code)Hair,
   decode(off_prof.profile_type,'EYE_COLOR',off_prof.profile_code)Eyes,
   decode(off_prof.profile_type,'RACE',off_prof.profile_code)Race

from

off_prof

where

(profile_type = 'HEIGHT'or profile_type = 'WEIGHT' or profile_type = 'HAIR_COLOR'or profile_type = 'EYE_COLOR' or profile_type = 'RACE')

this give me a row for each profile type for each individual, what I need to see is one row per individual with all the identifiers.

any suggestions would be appreciated

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 09:55:40 CDT