Select in select statement

I am running MySQL version 4.0.18.NT and I am having a problem.

The following statement works fine:

SELECT reportid FROM reportfiles WHERE username IN ('chris','terry','dave');

And the following statement works:

SELECT username FROM users;

But this does not work:

SELECT reportid FROM reportfiles WHERE username IN (SELECT username FROM
users);

Is this a bug or unsupported feature? Surely not the case...

Thanks, Chris

      Chris Tate-Davies Tel: 01608 647 651
      Technical Manager Email: chris.tatedavies@xxxxxxxxxx
      CETA Limited Web: www.ceta.co.uk