Re: Query Help

can't remember for sure but if its something that oracle allows 'outer joins' can better give you the results that you require.

    +----------------------------------------------------------+
    |Konstantino Mathioudakis  (konstantino_at_McMaster.ca)       |
    |             McMaster University (905 525-9140 ext 27210) |
    |:-)                        Programmer / Analyst           |
    |             CIS - Gilmour Hall, Rm 216, Hamilton Ontario | 
    +----------------------------------------------------------+ 	   

	

On Mon, 2 Oct 2000, Ashish Shah wrote:

> 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!
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Oct 02 2000 - 15:17:20 CDT