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>


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

Original text of this message