sqlite - Unsupported Sql Update With From

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 82,84 ****
--- 82,90 ----
  			measure = ( SELECT measure FROM t2 WHERE t2.key =
  t1.key ) WHERE t1.key = ( SELECT key FROM t2 WHERE t2.key=t1.key)
  		;
+ {linebreak}
+ *Kamil:2007-02-22*{linebreak}
+ or something like that that is more clearer to understand for me:{linebreak}
+ UPDATE t1{linebreak}
+ SET measure = ( SELECT measure FROM t2 WHERE t2.key =t1.key ){linebreak}
+ WHERE EXISTS (SELECT * FROM t2 WHERE t2.key=t1.key);{linebreak}