update `transaksi` 
set notuntutan = 'BDS'
WHERE kodtrx = 'BTL'
AND jenistrx = 'C'
AND tarikhtrx = '2007-12-15'
AND amaun = -248

SELECT * 
FROM transaksi
WHERE tarikhtrx = '2007-12-15'
AND jenistrx = 'C'
AND (
kodtrx = 'BS'
OR kodtrx = 'BYP'
OR kodtrx = 'BDA'
OR kodtrx = 'BDS'
)
ORDER BY noakaun, kodtrx