Sorry, just a copy paste error.
the second select is from table2.
:-)

Thanx for pointing it out.
Mahesh.

Helen Borrie <helebor@...> wrote:
At 05:06 AM 22/01/2004 +0000, you wrote:

>create procedure...
>begin
> for
> select col1, col2 from table1 where col1= order by col1
> union
> select col1, col2 from table1 where col1= order by col1
> do
> suspend;
>end
>
>If I remove the order by clause, it works fine. What I want, is that the
>total resulset should be sorted.
>Can someone help me out to figure this?
>

Just interested to know why you want to union this.

Why not just
select col1, col2 from table1 where col1 in (const1, const2) order by col1

/hb




Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



---------------------------------
Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now

[Non-text portions of this message have been removed]