Also use "union all" rather than "union". Unless you need duplicates eliminated, "union" will run longer to eliminate duplicates.
Regards, Ken ----- Original Message ----- From: Jan Barley Date: Monday, October 27, 2008 11:29 am Subject: [RBASE-L] - RE: Union Select To: [email protected] (RBASE-L Mailing List) > Yeah Dennis! Thanks so much! That did it!!! Have a great day! > > Jan >

