dificult SQL

From: <chemarey_at_my-deja.com>
Date: Tue, 09 Jan 2001 15:53:22 GMT
Message-ID: <93fc5f$r03$1@nnrp1.deja.com>

Hi. I'd like to know how can i order the elements of a query with UNION.

For example:

select customer,inc from table1
UNION
select customer,inc from table2

The idea is order by the inc item, but DBMS returns an error if a put the order by clause in the two different selects like

select customer,inc from table1 order by inc asc UNION
select customer,inc from table2 order by inc asc.

Do you know if is possiblke to do this and how can i do.

                                   Thanks.

Sent via Deja.com
http://www.deja.com/ Received on Tue Jan 09 2001 - 09:53:22 CST