Ok now I am running this statement
UPDATE products INNER JOIN products_ums ON products.products_id = products_ums.products_id SET products_ums.products_ums_price="552" WHERE ( products.products_model="2420-01" OR products.products_model="242001") AND products_ums.products_ums_um="EA"; and I am getting a 1064 error I am lost at this point. Your help would be appreciate it. Thanks, Kuai
