I think I got it -- I had to create a cursor and then populate the cursor with several SELECT statements.

Thanks for the response.
Doug