I have an srf sql function "annual_report(<year>)" that
as 14 columns, a category, 12 month numeric columns, and a total
numeric column.
The function finds monthly totals for each category (which is the
target of "order by")
and the grand total for the specified year.
I have another sql function annual_profit_loss(<year>) that summarizes
the total
for each month and the grand total for each year. ( There is a text
column that
serves a label.) It generates a summary for the annual_report function
in essence.
I have hoped that
select * from annual_report(2003)
union
select * from annual_profit_loss(2003)
would print the last select last ;( but it inserts the last selection
alphabetically into the rows of the annual_report depending on the label
field... I suppose I could use a label "zzGrand Totals", but that just
does not look right.
Is there any way I can force the last select to appear last?
Jerry