kris.womack (10/7/2010)

---

I think you need to specify the database context for the table in the where clause. You handled this in the main query but not in the sub query.