Thread: Syntax For Count help
View Single Post
  #2 (permalink)  
Old 2007-02-18, 02:46 PM
flann flann is offline
Member
  
Join Date: Jun 2006
Posts: 55
flann is on a distinguished road
Default
count is an aggregate function and cannot be used in this fashion. You'll need to do two separate queries, or use a sub query if available.
__________________
flann
Free Mortgage Calculator | Debt Free
Reply With Quote