Re: HOW TO INCLUDE THE SOURCE TABLE IN A QUERRY

From: Hagai Katz <katzh_at_bgumail.bgu.ac.il>
Date: Tue, 14 Aug 2001 15:47:00 +0300
Message-ID: <9lb6k7$gqd$1@news.huji.ac.il>

Thanks to both of you.
Both ideas work fine.

"Adi Cohn" <adicohn_at_hotmail.com> wrote in message news:O505ZxLJBHA.1840_at_tkmsftngp02...
> 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 - 07:47:00 CDT