I don't why I didn't think of that, Thanks Paul

mike

-----Original Message-----
From: Paul Beach [mailto:pabeach@...]
Sent: Tuesday, January 22, 2002 3:57 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Union All with Order By

> Is there any way to use a "Order By" with a query like this?
>
> select * from ks where city='COUNCIL GROVE'
> UNION ALL
> SELECT * from MO where city='RAYTOWN'

With Unions you order by the field no and not the field name, so on a....

select field1, field2 from a
UNION
select field 1, field2 from b
order by 2, 1

Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information



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



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