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:330747 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
