I have the following query that I need to get the sum of the sysPrice
from. I keep getting an the ol aggregate function or group by error, can
someone help please?
SELECT com.typeID,
com.partNum,
com.description,
com.currentType,
com.salePrice,
com.sysPrice,
parts.isDefault,
parts.sysModelNum
FROM system_parts AS parts
INNER JOIN components AS com
ON parts.partNum = com.partNum
WHERE parts.sysModelNum = '#sysModelNum#'
ORDER BY com.typeID, com.partNum
<CF_SIGNATURE
NAME="Douglas L. Brown"
EMAIL="[EMAIL PROTECTED]"
PHONE="714.538.6611"
WEB="http://www.carnivorepc.com";>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
