UNION Don't Like ORDER BY in Interbase SQL

Lotfi ZEMALI

Delphi Developer

Tue, 20 May 2003 03:00:00 GMT

UNION Don't Like ORDER BY in Interbase SQL

Hi,
I tried to write a query in Interbase wich looks like this
Select <Colums>
from tablex
where <Cond>
Union
Select <Same Colums>
from tabley
where <Cond>
Order By <Col>
This Query don't worl on Interbase SQL, I can't use Order By with Union,
So I tried tu use Views, but Create View don't accept UNION,
so my question is how to sort a query that contain a Union clause
Thanks

Craig Stunt

Delphi Developer

Tue, 20 May 2003 03:00:00 GMT

Re:UNION Don't Like ORDER BY in Interbase SQL

Quote

Lotfi ZEMALI wrote:

> This Query don't worl on Interbase SQL, I can't use Order By with Union,

It will work, but you have to specify the column in the ORDER BY
numerically, i.e., ORDER BY 1

Quote

> So I tried tu use Views, but Create View don't accept UNION,

It should in IB 6.

HTH,

-Craig

--
Craig Stuntz Vertex Systems Corporation
Senior Developer http://www.vertexsoftware.com

Delphi/InterBase weblog: http://delphi.weblogs.com

Sergio Enrique Samayo

Delphi Developer

Tue, 20 May 2003 03:00:00 GMT

Re:UNION Don't Like ORDER BY in Interbase SQL

Lotfi ZEMALI escribi en mensaje <3a27fdc5_2@dnews>...

Quote

>Hi,
>I tried to write a query in Interbase wich looks like this
> Select <Colums>
> from tablex
> where <Cond>
>Union
> Select <Same Colums>
> from tabley
> where <Cond>
>Order By <Col>

<Col> is ordinal number or column name ? You should use ordinal name since
you are mixing data from diferent tables.

Quote

>This Query don't worl on Interbase SQL, I can't use Order By with Union,
>So I tried tu use Views, but Create View don't accept UNION,
>so my question is how to sort a query that contain a Union clause
>Thanks

Lotfi ZEMAL

Delphi Developer

Wed, 21 May 2003 13:22:46 GMT