update A set A. nature='XXX' from A, B, C where A.id=B.rowid and B.rowid=C.kid and (这里写你的条件, 比如什么哪个表的ID)