documentation/Reference Code/Wedge/installation/mysql/is4c_log/views/mitendertotal.viw
use is4c_log;
DROP VIEW IF EXISTS `mitendertotal`;
CREATE VIEW `mitendertotal` AS
select
`mitenders`.`register_no` AS `register_no`,
`mitenders`.`emp_no` AS `emp_no`,
sum(`mitenders`.`MiTender`) AS `miTender`
from `mitenders`
group by `mitenders`.`register_no`