Is it possible to have a stored procedure in FB execute two separate SELECT
statements, and return a merged set of results back? Forgive me being a
newbie to creative SELECT statements in SQL, but I have a set of data that I
can get with one select statement, and then another set of data from the
same table with another SELECT statement, and I want to return these back
from the stored procedure in a sorted order so that the first set of results
appear first, and the 2nd set of results are 'appended' onto the set.

Can this be done?

Myles


============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org