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?