how to emulate a simple case of a view on unions

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