At 05:16 AM 22/01/2004 +0000, you wrote:

>Thanx for the prompt reply.
>But even if I put one order by clause after all select it is giving me
>'invalid order by clause' error.
>
>create procedure...

as
declare variable var1 date;
declare variable var2 whatever;

>begin
> for
> select (current_date - col1) , col2 from table1 where col1< current_date
> union
> select (current_date - col1), col2 from table1 where col1< current_date
> order by col1

into :var1, :var2

> do
> suspend;
>end
>/*col1 is a date field*/
>
>Firebird version :
>ISQL Version: WI-T1.5.0.3481 Firebird 1.5 Release Candidate 3
>Firebird/x86/Windows NT (access method), version "WI-T1.5.0.3481 Firebird
>1.5 Release Candidate 3"
>on disk structure version 10.1
>
>Is this query fine?
>

Nope.

/hb