在table1里面加一个字段OAID,如果packId相同,将table2里面的OAID同步到table1
Update aset a.OAID =b.OAIDfrom table1 a inner join table2 bon a.PackID = b.PackID