Charlotte Foust
cfoust at infostatsystems.com
Fri Oct 28 10:06:11 CDT 2005
IN is faster than NOT IN because it doesn't have to search the entire list every time. Charlotte -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, October 28, 2005 7:42 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Update query broke Hi John Without your SQL I guess you have some joins. Replace these with .. IN ( .. ) or .. NOT IN ( .. ) constructs. For very large tables that may too slow. If so, create a temp table with the selected output, then use this to update the other tables. /gustav >>> jwcolby at ColbyConsulting.com 27-10-2005 20:59:48 >>> That was it. Now I am getting "updating data in a linked table not supported by this ISAM". The linked table is in the BE, and I have never seen this on before. Sigh. I guess I pull the queries into the BE and do it there. John W. Colby -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com