西软删除消费账记录

[landv]

select * from master  where 1=1 and cat='C' and accnt ='C001112'

SELECT * FROM account WHERE accnt ='C001112' AND number in (33,34)

DELETE
FROM xms.account
WHERE accnt ='C001112' AND number in (33,34)
``