Tim -- you may be able to use a derived table in the FROM clause to get around this. If you could post a bit of the code I will try reworking it to show you what I mean.
>I am trying to specify a select statement as a column in SQL 7.0. The query contains a Group By clause and I am getting an error telling me I cannot perform an aggregate on expression that contains a subquery. Is there a way around this?
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell