CORE-POS/IS4C

use is4c_log;
DROP VIEW IF EXISTS `memchargetotals`;

create view memchargetotals as
select 
card_no, 
sum(total) 
as chargeTotal from dtransactions where trans_subtype = 'MI'
group by card_no