update tablename set
fieldname = valueor
update tablename set
fieldname =
(select value from table2 where ...) //必须保证只有一条数据返回,
fieldname = valueor
update tablename set
fieldname =
(select value from table2 where ...) //必须保证只有一条数据返回,
但是paradox不支持这个函数