CirquedeSQLeil (1/27/2010)

---

honza.mf (1/27/2010)

---

I answered OK, but...

The first variant with IN can be more effective, it allways depend on data. Compare two queries without any knowledge about structure of tables, indexes, possible data distributions...

This is a very valid point - the answer really is an It Depends kind of answer.