Hello, I want to have a query with some records from a table and after that,
some records from another table. The only way I can think of doing that is with
a stored procedure.

pseudocode:

for select (my fields) from table_1 into (my output vars) do
begin
suspend;
end

for select (my fields) from table_2 into (my output vars) do
begin
suspend;
end

Is there another (better) way?
Both tables has the same field names.









Thanks! -s