Small. Fast. Reliable.
Choose any three.
*** 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