View Single Post
  #1 (permalink)  
Old April 30th, 2007, 11:49 AM
carswelljr carswelljr is offline
Authorized User
 
Join Date: Aug 2006
Location: , , .
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default new display count query

SELECT v.category, COUNT(v.category) AS issue_count, c.color
FROM TICKET_VIEW v, COLORTBL c
WHERE (c.min_issues > issue_count) AND (c.max_issues <= issue_count)
GROUP BY v.category
ORDER BY v.category


i keep getting these errors:
"you tried to execute a query that does not include the specified expression 'color' as part of an aggregate function."
or
"no value given for one or more parameters."

can someone tell what i am dong wrong and why this query will not execute?
thank you

Reply With Quote