Is there a better way of writing this kind of thing?

```
SELECT * from table_a WHERE id NOT IN (SELECT id FROM table_b)

```

It's shown [here](http://www.mysqlperformanceblog.com/2006/08/31/derived-tables-and-views-performance/) that views are faster than subqueries, but it's not like you can do `SELECT * FROM table_a WHERE id NOT IN view_b`, so I'm curious if there's a better way or if that's just what we have to live with.