插入数据1insert into TbYTZ(UserID) select UserID from TbUser更新数据则在TbUser和TbYTZ两个表要有一个关系。。。如TbUser.a1=TbYTZ.a21UPDATE TbYTZ SET TbYTZ.UserID = (SELECT UserID FROM TbUser WHERE TbUser.a1=TbYTZ.a2)