Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> HOW TO INCLUDE THE SOURCE TABLE IN A QUERRY
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:19:11 CDT