What database server are you using? It will help to know since sub-queries may work, but only in certain database servers and versions.
========================================
Buh Bye!
Cheers,
Me
========================================
Buh Bye!
Cheers,
Me