HOW TO INCLUDE THE SOURCE TABLE IN A QUERRY
From: Hagai Katz <katzh_at_bgumail.bgu.ac.il>
Date: Tue, 14 Aug 2001 15:19:11 +0300
Message-ID: <9lb4vv$fre$1_at_news.huji.ac.il>
Date: Tue, 14 Aug 2001 15:19:11 +0300
Message-ID: <9lb4vv$fre$1_at_news.huji.ac.il>
Hi fellows,
I want to unite data from two tables, like this:
SELECT ID, LOCATION, DATA_TYPE FROM NIH1995
UNION
SELECT ID, LOCATION, DATA_TYPE FROM NIH1996;
but want to know from which of the two tables came every row in the results.
Any suggestions on how to do that?
Thanks,
Hagai.
Received on Tue Aug 14 2001 - 14:19:11 CEST