documentation/Reference Code/Wedge/installation/mysql/translog/views/suspendedlist.viw
use translog;
DROP VIEW IF EXISTS `suspendedlist`;
create view suspendedlist as
select
register_no,
emp_no,
trans_no,
sum(total) as total
from suspended
where datediff(datetime, now()) = 0
group by register_no, emp_no, trans_no