熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle 多表關聯更新多個字段 帶條件

2013-11-13 22:10:38  來源: Oracle 

  update student A

  set (Anameadq) =

  (select Bbnamebbdq

  from newstudent B

  where BBid = Aid

  and Adq =

  )

  where exists (select

  from newstudent B

  where BBid = Aid

  and Adq =

  );

   


From:http://tw.wingwit.com/Article/program/Oracle/201311/18385.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.