*** 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) =