OT observation: this doesn't directly relate to your
problem, but you have no table join condition on
tblUsers in your query.
>
> Query:
> SELECT
> u.first_nm
> , u.last_nm
> , c.category_nm
> , c.category_id
> , c.dataType
> , c.department_id
> , SUM(dn.quantity_nb)AS totalForMonth
> , g.goal_nb
> FROM
> tblcategories c
> , tblDailyNumbers dn
> , tblUsers u
> , tblGoals g
> WHERE
> c.department_id = 1
> AND
> DatePart("mm", dn.date_dt) = 9
> AND
> DatePart("yy", dn.date_dt) = 2001
> AND
> c.Category_id *= g.Category_id
> AND
> c.category_id *= dn.category_id
> GROUP BY
> u.last_nm
> , c.category_nm
> , c.category_id
> , c.department_id
> , g.goal_nb
> , c.dataType
> , u.first_nm
=====
I-Lin Kuo
Macromedia CF5 Advanced Developer
Sun Certified Java 2 Programmer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
