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
>
>************
>
