Hi Friends,
I'm having a problem in making a query.
I've a table like:
Code  Min_pts  Max_pts  Pts_Value
-----     ------        -------       ---------
tmp1  10          25            20
tmp1  26          50            35
tmp1  51         100           60
tmp2  10         25             18
tmp2  26         50             40
tmp2  51         100           88
 
I want to build a query which should return me records like
code  pts_value
-----  ---------
tmp1  20,35,60
tmp2  18,40,88

Please help me as it is very urgent.
 
Thanks in advance.              

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to