Patricia G.L.Hall wrote: > > I tried to implement this 3 ways. 2 gave me errors (cause they're > wrong) and 1 didn't give me the results I needed. Referring back to > the shorter query I started out with:
Maybe you should try to explain in words what you are trying to achieve, because I am getting the impression that the code is much more complicated then what is actually needed. > Cannot perform an aggregate function on an expression containing an > aggregate or a subquery What database are you using? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
