Yes that works but unions only work if all the selects return columns of the
same type in the same order.

-----Original Message-----
From: Rotandiko Sastroprawiro [mailto:rsastroprawiro@...]
Sent: 29 July 2002 03:53
To: 'ib-support@yahoogroups.com'
Subject: [ib-support] get record from 3 selection


Dear All,

How can i merge a result from 3 "SELECT" ?, like this

SELECT ID FROM X
UNION
SELECT ID FROM Y
UNION
SELECT ID FROM G

Regards,

Diko



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/