update ord a inner join room b on a.roomno=b.roomno inner join flat c on a.flatno = c.flatno and a.flatsub=c.flatsub set a.xrea = b.xrea, a.ritysubn=b.ritysubn, a.blockno=b.blockno, a.blockn=b.blockn, a.part=b.part, a.unit=b.unit, a.layer=b.layer, a.home=b.home, a.flatn=c.flatn;