1樓：匿名使用者
把子查詢前面的=換成 in 試試？
update study set received_code='taiycg1' where received_code in (select study.received_code from study,series where study.studyinstanceuid=series.
studyinstanceuid and songjiandanwei like '%水西關%' and seriesdate between'2012-1-1' and '2012-4-6'and workflow='st' )
2樓：匿名使用者
update study set received_code='taiycg1' where received_code
in (select study.received_code from study,series where study.studyinstanceuid=series.
studyinstanceuid and songjiandanwei like '%水西關%' and seriesdate between'2012-1-1' and '2012-4-6'and workflow='st' )
試試這個！
sql分段查詢語句怎麼寫，SQL語句中，按時間段間隔查詢怎麼寫？
什麼庫？sqlserver access oracle？access的話 還是在表裡多設定一個欄位讓他自動增減吧！sqlserver的話 select identity int,1,1 rownum,name into temp from 表 select from temp where rownu...
sql連線查詢語句中from子句中表的順序有什麼要求
嚴格上來說是沒有要求的，他們有兩種寫法，一種是ansi sql,一種是trans sql.ansi sql select from table1,table2,table3 where table1.id table2.id and table3.id table2.pid trans sql se...
sql語句中怎麼實現in中的模糊查詢
where substr phone,0,3 in 134 135 通過擷取phone的前三位，要學會變通。模糊查詢要活用啊。where phone like 13 45 這樣可以去除134或135開頭的資料。使用正規表示式試試，mysql支援。你用的oracle嗎？是的話請追問，where條件後用...