select loanid,loantypeid,loanno,intrate, *from loanmain where loandate>='2074/04/01' order by loandate asc

update loanmain set intrate=18 where loandate>='2074/04/01'

select * from loantypedetails
update loantypedetails  set intrestrate=18 where ltdid in
(1,
2,
3,
4,
5,
6,
7,
8)

select * from savingtype
update savingtype set taxonintrest=5, prid=198 where savingtypeid in
(1,
2,
3,
4,
5,
6,
7,
27,
30)



select * from
update savingtype set prid=198 where savingtypeid in
(1,
2,
3,
4,
5,
6,
7,
27,
30)




select * from savingtype
select * from acctree where id=94
select * from acctree where name like 'tds%'
select * from ledger where accountheadid=198