----- Original Message -----
From: "Lourenço de Paula" <lourenco.d@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, March 14, 2003 11:02 AM
Subject: [ib-support] Union and order by


Hello

I'm trying to execute the follow statement:

SELECT FIELD_A X FROM TALBLE_A
WHERE FIELD_A > 100
UNION
SELECT FIELD_B X FROM TALBLE_B
WHERE FIELD_B > 100
ORDER BY X