|
发表于 2020-2-7 01:15:01
|
显示全部楼层
between x and y,x,y皆是常数。
adoquery1.sql.add('
update daa074 set skqk=''i''
from daa074 a
where daa074.elsyds >=(select daa091.jdds1 from daa074 where id = a.id) and daa074.elsyds <=(select daa091.jdds2 from daa074 where id = a.id)
');
其中的ID字段换成该表的关键字字段 |
|