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

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(at)astro(dot)umass(dot)edu
>University of Massachusetts http://www.astro.umass.edu/~weinberg/
>Amherst, MA 01003-4525
>
>************
>