20230221.tex 399 字节
-- UPDATE score_task_details a, user_families b SET a.family_name = b.name,a.family_number=b.number,a.family_address=b.address WHERE a.family_id=b.id

UPDATE score_task_details a, users b SET a.scorer_name = b.name,a.scorer_mobile=b.mobile ,a.scorer_group_id=b.group_id WHERE a.scored_by=b.id

UPDATE score_task_details a, user_groups b SET a.scorer_group_name = b.name WHERE a.scorer_group_id=b.id