CORE-POS/IS4C

use is4c_log;

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

select 
`cctenders`.`register_no` AS `register_no`,
`cctenders`.`emp_no` AS `emp_no`,
sum(`cctenders`.`ccTender`) AS `ccTender` 

from `cctenders` 
group by `cctenders`.`emp_no`