I checked the MySQL documentation, and subqueries weren't supported until 4.1. If it weren't for the fact that upgrading databases is a dangerous and scary process, I'd say get version 5 or 6. Then again, it'll have to be done eventually for Drupal 7.