You just need a JOIN and GROUP BY clause. Check out the subquery-to-join docs on MySQL's site. They have examples of how to do exactly what you want.
cheers, barneyb On Mon, Feb 15, 2010 at 11:19 AM, Barry Mcconaghey <[email protected]> wrote: > > I'm using MySQL 4.0.20. > > Is there any other way to total these two fields? > > Barry > >>What version of MySQL are you using? If it's a really old one that >>doesn't support subqueries, check out the MySQL docs. They have a >>section about rewriting subqueries into JOINs. >> >>cheers, >>barneyb > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330749 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
