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?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé