<--- --------------------------------------------------------------------------------------- ---- Blog Entry: SQL Optimization Case Study - JOIN Clause vs. IN Clause Author: Ben Nadel / Kinky Solutions Link: http://www.bennadel.com/index.cfm?dax=blog:940.view Date Posted: Sep 4, 2007 at 6:02 PM ---- --------------------------------------------------------------------------------------- ---> ... WHERE id IN ( SELECT u.id FROM @users u )