UPDATE invoice.reading_group_customer rgc LEFT OUTER JOIN invoice.customer c ON rgc.customer_code = c.customer_code SET rgc.customer_group = c.customer_group WHERE rgc.any_code = '03043001'