CORE-POS/IS4C

USE `is4c_log`;

DROP VIEW IF EXISTS `fstendertotal`;
CREATE VIEW `fstendertotal` AS SELECT 
    `fstenders`.`register_no` AS `register_no`,
    `fstenders`.`emp_no` AS `emp_no`,
    SUM(`fstenders`.`FsTender`) AS `fsTender` 
    FROM `fstenders` 
    GROUP BY `fstenders`.`register_no`