Query Help

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Mon, 2 Oct 2000 11:33:28 -0700 (PDT)
Message-Id: <10637.118335@fatcity.com>

Hi All,

I have a table called
user_prop
(user_id ,prop_id,prop_value)

When I do select user_id,prop_value from user_prop where prop_id in ('BDATE','SEX','CITY');

It would display like..  

1234 18051999
1234 Male
1234 Toronto

Is there a way to display result like..

1234 18051999 Male Toronto --in one row..!!

Thanks.
Is there a way to display query results

---

Ashish
Toronto, Canada

---

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! Received on Mon Oct 02 2000 - 13:33:28 CDT