JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » JDBC/SQL討論區 » Oracle  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友    訂閱主題
reply to topicthreaded modego to previous topicgo to next topic
本主題所含的標籤
無標籤
作者 子查詢為什麼可以用到外部查詢的條件值
eddiebin





發文: 110
積分: 0
於 2011-09-15 16:37 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
update tbl aa1 set aa1.decrease_desc = 'XXXX-' || (
select c.comp_abbr
from tbl1 a,tbl2 b,tbl3 c
where c.no = b.no
and trim(b.no) is not null
and b.cno = a.ord
and a.no = aa1.no )
where aa1.ono = 'ORD0006518651'

語法大概是這樣,請有經驗的大大告知一下小弟,謝謝


reply to postreply to post
» JWorld@TW »  JDBC/SQL討論區 » Oracle

reply to topicthreaded modego to previous topicgo to next topic
  已讀文章
  新的文章
  被刪除的文章
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8