Thanks for the quick answer, that does return 4.0 for me also. So I don't understand why basic subqueries won't work. Any ideas?
Nevermind, just found out that subqueries require 4.1 or higher. Somewhere else I read it was only in 3.x that they weren't supported. Guess I have to wait for DH to get with it and upgrade!