About between and ~~~~~~~~ `

ekinzou

If the value of skqk is between daa091.jdds1 and daa091.jdds2, write I

This is possible, but you must first determine which record in the daa091 table and then replace daa091.jdds1, daa091.jdds2 with: select jdds1 from daa091 where ...
     select jdds2 from daa091 where ....

yourapy

Between x and y, x, y are constants.
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)
');
The ID field is replaced with the key field of the table