>Hello all,
>
>I have a cursor generated by a bunch of SQL subqueries. The data in that cursor is primary keys.
>
>I want to be able to select three records in another cursor for each primary keys that are a part of that cursor.
>
>So Cursor with primary keys looks like this
>
>12354
>3456
>23
>
>Result that I would like to have
>
>12354 Whatever1
>12354 Whatever2
>12354 Whatever3
>3456 Something1
>3456 Something2
>3456 Something3
>23 Other1
>23 Other2
>23 Other3
>
>Can this be done with a SQL construct?

Hi Denis,

the cheapest way without brain squeezing:

create cursor curhelp (i1 I)
append blank
append blank
append blank

select;
 cur1.*,;
 Cur2.i1;
 from yourcursor as Cur1;
 inner join curhelp as Cur2;
  on .t.;
 into cursor curTarget

use in curhelp