Hello !

SQL for beginners ;-) ?????

In my maxdb database i can select the following as result cursor from
different tables: 

projectno, activity, feedbackno 
a           x     1
a           y     2
a           z     3

b           x     10
b           y     11
b           z     12

c           x     14
c           y     15
c           z     16

There are allways the same 3 activities per projectno with unique
feebackno

I need one record for each projectno !???

projectno acx  feedbacknox   acy      feedbacknoy acz   feedbacknoz
a          x      1             y     2                 z       3
b          x      10            y     11                z      12
c          x      14            y     15                z      16

I don't know how to select this from my result cursor ??

Any help welcomed

Best regards

Albert

                    '''''
                  ''''''''' 
                    (0 0) 
 +---------oOO-------(_)-------------------+ 
 | Tel: 0541/5841-868                      | 
 | Fax: 0541/5841-869                      | 
 | Mail: mailto:[EMAIL PROTECTED]  |  
 | Internet:  http://www.piepenbrock.de    |
 +-------------------------------oOO-------+ 
                   |__|__| 
                    || || 
                   ooO Ooo 


Reply via email to