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_at_4ax.com>
Date: Wed, 14 Aug 2002 14:57:59 +0200
Message-ID: <v4jkluk4bksqknk2gtejn090cgdd0b7r1q_at_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 - 14:57:59 CEST