I want to use an aggregate function in the WHERE clause and SQL Server 7
won't let me? Specifically, I need to find a customer ID where the budget
is equal to MAX(budget). Is my logic wrong? How can I display the the
customer ID with the biggest budget? Any help is really appreciated. TIA