[EMAIL PROTECTED] wrote: > > 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 ?? >
select x.*, y.activity, y. feedbackno, z.activity, z.feedbackno from tab x, tab y, tab z where x.projectno = y.projectno and y.projectno = z.projectno and x.activity = 'x' and y.activity = 'y' and z.activity = 'z' should do. Elke SAP Labs Berlin > 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 > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
