oracle update an1 set an1.anlnane = (select asr.asrname from asr ,an1 where anl.anlnum=asr.anlnum) where where anl.anlnum=asr.anlnum sql server update an1 set an1.abnnale = asr.anlname from an1 ,asr where where anl.anlnum=asr.anlnum
才20分!不过还是告诉你吧! oracle update anl set anl.anlname = (select asr.asrname from asr where asr.anlnum=anl.anlnum) 给分!!!
update an1 set an1.anlnane = (select asr.asrname from asr ,an1 where anl.anlnum=asr.anlnum) where where anl.anlnum=asr.anlnum
sql server
update an1 set an1.abnnale = asr.anlname from an1 ,asr where where anl.anlnum=asr.anlnum
oracle
update anl set anl.anlname = (select asr.asrname from asr where asr.anlnum=anl.anlnum)
给分!!!