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.