Gavin


SELECT authors.* ;
FROM firstpass_cursor, authors ;
WHERE UPPER(mytable.au_lname) = firstpass_cursor.au_lname ;
INTO CURSOR secondpass_cursor ;
ORDER BY firstpass_cursor.au_lname

Mohemmed