I have two tables: companies, purchased_services... for each company in the companies table I want to sum up the annual_service_charge for each row that is associated with teh company in purchased_services.
I have the following query: SELECT company_id, SUM(annual_service_charge) FROM purchased_services GROUP BY company_id; This above gives me the company_id and service charge. How do I now put that SUM(annual_service_charge) into companies.total_annual_service_charge? Thanks my friends :-). -- John Kopanas [EMAIL PROTECTED] http://www.kopanas.com http://www.cusec.net http://www.soen.info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
