CORE-POS/IS4C

use is4c_log;

DROP VIEW IF EXISTS `dctendertotal`;
CREATE VIEW `dctendertotal` AS 

select 
`dctenders`.`emp_no` AS `emp_no`,
sum(`dctenders`.`dcTender`) AS `dcTender` 

from `dctenders` 
group by `dctenders`.`emp_no`