*** 18,24 **** update T1 set (theUpdatedValue, theOtherValue) = (select theTop, theValue from T2 where T2.theKey = T1.theID) ! *: free text search capabilities in select statements: Mysql does free text search Match(field_list) Against(keyword) *: Multiple databases are not supported. For example, the following construct --- 18,24 ---- update T1 set (theUpdatedValue, theOtherValue) = (select theTop, theValue from T2 where T2.theKey = T1.theID) ! *: 2005.09.25 : free text search capabilities in select statements: Mysql does free text search Match(field_list) Against(keyword) *: Multiple databases are not supported. For example, the following construct