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

[Martin Weinberg]

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          [EMAIL PROTECTED]
University of Massachusetts          http://www.astro.umass.edu/~weinberg/
Amherst, MA  01003-4525

************