Right. I like this method. I try to craft my where clauses so there will never be any overlap in the data sets that are unioned. When that is done you get the union without the slowness.
Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 27, 2008 12:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Union Select 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 >
