*** 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}