CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_emp_final` AS
    SELECT 
        `a`.`emp_id` AS `emp_id`,
        CONCAT(`a`.`firstname`,
                _LATIN1' ',
                `a`.`lastname`) AS `fullname`,
        `a`.`comp_id` AS `comp_id`,
        `a`.`yr_hours` AS `yr_hours`,
        `a`.`Jan` AS `Jan`,
        `a`.`Feb` AS `Feb`,
        `a`.`Mar` AS `Mar`,
        `a`.`Apr` AS `Apr`,
        `a`.`May` AS `May`,
        `a`.`Jun` AS `Jun`,
        `a`.`Jul` AS `Jul`,
        `a`.`Aug` AS `Aug`,
        `a`.`Sep` AS `Sep`,
        `a`.`Oct` AS `Oct`,
        `a`.`Nov` AS `Nov`,
        `a`.`Dec_h` AS `Dec_h`,
        `b`.`companyname` AS `companyname`
    FROM
        (`vw_emp_hrs5` `a`
        JOIN `company` `b`)
    WHERE
        (`a`.`comp_id` = `b`.`comp_id`)