*** 60,62 **** --- 60,64 ---- SET measure = ( SELECT measure FROM t2 WHERE t2.key = t1.key ) ; + + _:: But be very careful with this code! The original joined update would only update where a record is found with the key in both tables. This, on the other hand, will update everything in t1, setting measure to NULL if there isn't a record in t2. *TJH:2006-03-24*
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|