Re: SQL query for joining results of queries

From: GoranG <no_at_spam.net>
Date: Wed, 14 Aug 2002 14:57:59 +0200
Message-ID: <v4jkluk4bksqknk2gtejn090cgdd0b7r1q@4ax.com>

On 6 Aug 2002 00:43:20 -0700, srigurunath_at_yahoo.com (Ecap) wrote:

>Hi,
> This may be a simple question (?)

<cut>

There is also UNION

SELECT C, 'T1' AS TableName FROM T_1
UNION ALL
SELECT C, 'T2' AS TableName FROM T_2
UNION ALL
SELECT C, 'T3' AS TableName FROM T_3

Seems other posted solutions are better - but just wanted to mention this since the subject hints that this just might be enough...

( GoranG79 AT hotmail.com ) Received on Wed Aug 14 2002 - 07:57:59 CDT