legend8,
It appears that you wish to do a derived table and unfortuantely that is not possible in the current BO configuration. I hoped that they would have changed that by now (we are currently using 5.1.2), but we have to get our queries to run by creating subselects, or doing what Bobward suggested and have a view created to give you desired results.... Hope this helps
B