Re: HOW TO INCLUDE THE SOURCE TABLE IN A QUERRY

  Add a constant to each one of the select statments:

SELECT ID, Location, Data_Type, 1995 FROM NIA1995 UNION
SELECT ID, Location, Data_Type, 1996 FROM NIH1996

Adi
"Hagai Katz" <katzh_at_bgumail.bgu.ac.il> wrote in message news: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 - 08:20:20 CDT