freegink · 2006-03-07 03:03:38 · 阅读: 758 帮忙看看,使用ado执行下面语句,为什么非常慢? SELECT * FROM Data WHERE Year LIKE '%2005%' AND Company NOT IN (SELECT DISTINCT Company FROM Data WHERE Year LIKE '%2006%''