Yes in trial runs, with the files table only having 50,000 or so records, it seems to make no appreciable difference on speed. Just gotta get used to using it (like anything).

thanks

>
>Agree that EXISTS is better here because it makes really clear what you're looking for. I suspect it'll get optimized anyway into one query that collects the whole set and then is filtered for each record. So I'd be surprised if there's a significant speed difference.
>
>Tamar