Hello

I am attempting to write a stored procedure that will return me
multiple rows. I need to run 2 seperate selects and then process these
results in 3rd (nested?) query.
My pseudo code statment looks something as follows:

for select <specs>
into <vars>
select <spec>
into <vars>
do
begin
<nested statements>
end

The question that I have is concerned with the 2nd select. Is this a
nested loop itself and should it be wrapped in a begin and end ? I
expect that the select query will return multiple rows for the 2nd
query to use before passing on to the 3rd.

As always any help is greatly appreciated.

Brendan Donoghue