CORE-POS/IS4C

use is4c_log;

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

select 
`cktenders`.`register_no` AS `register_no`,
`cktenders`.`emp_no` AS `emp_no`,
sum(`cktenders`.`ckTender`) AS `ckTender` 

from `cktenders` 
group by `cktenders`.`register_no`