in reply to (OT) MySQL select Question

Apparently they already have subselects working in development, they've been promising them for MySQL 5.