Small. Fast. Reliable.
Choose any three.
*** 11,16 ****
--- 11,18 ----
      FROM table1 t1, table2 t2
      WHERE t1.t2_ref_id *= t2.id
  
+     This is Sybase ASE syntax. Related to "Oracle's join syntax" mentioned below
+ 
  *: This appears to be unsupported: updating multiple columns with subselect
  
     update T1 set (theUpdatedValue, theOtherValue) =