Mr. Myles,

In union sql statement order by have to insert by
column index number, that is 'order by 1 or 2...'
where 1 or 2 is column index.

Best Regards
Md. Shariful Alam Khan

--- Myles Wakeham <myles@...> wrote:

> > You can use 'union' statement in select statment.
>
> Thanks, but the problem is that I can't control the
> order of the rows
> returned this way. I believe, however, that Helen
> may have already answered
> this in a previous post by using the SUSPEND in the
> SP in a way that I
> wasn't aware I could do it.
>
> I'll try it this week and see how I go.
>
> Regards,
> Myles
>
> ===============================
> Myles Wakeham
> Director of Engineering
> Tech Solutions US, Inc.
> Phone (480) 451-7440
> www.techsol.org
>
>
>
>
>
>
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com