Thread: how to emulate a simple case of a view on unions

how to emulate a simple case of a view on unions

From
Martin Weinberg
Date:
I have four tables with identical fields and I would like
to automate the same query on each table and pool the
results.

Any suggestions on streamlining this?

Thanks!

--Martin


===========================================================================

Martin Weinberg                      Phone: (413) 545-3821
Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
530 Graduate Research Tower         weinberg@astro.umass.edu
University of Massachusetts         http://www.astro.umass.edu/~weinberg/
Amherst, MA  01003-4525

Re: [GENERAL] how to emulate a simple case of a view on unions

From
Charles Tassell
Date:
You could try combining it into one query spanning the four tables:
select tab1.field, tab2.field, tab3.file, tab4.field from
tab1,tab2,tab3,tab4 WHERE clause..;


At 10:59 PM 9/21/99, Martin Weinberg wrote:
>
>I have four tables with identical fields and I would like
>to automate the same query on each table and pool the
>results.
>
>Any suggestions on streamlining this?
>
>Thanks!
>
>--Martin
>
>
>===========================================================================
>
>Martin Weinberg                      Phone: (413) 545-3821
>Dept. of Physics and Astronomy       FAX:   (413) 545-2117/0648
>530 Graduate Research Tower         weinberg@astro.umass.edu
>University of Massachusetts         http://www.astro.umass.edu/~weinberg/
>Amherst, MA  01003-4525
>
>************
>