CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `vw_emp_hrs_new2` AS
    SELECT 
        `a`.`emp_id` AS `emp_id`,
        `a`.`comp_id` AS `comp_id`,
        `a`.`yr_hours` AS `yr_hours`,
        `a`.`mon_name` AS `mon_name`,
        `a`.`mon_hrs` AS `mon_hrs`,
        `b`.`firstname` AS `firstname`,
        `b`.`lastname` AS `lastname`
    FROM
        (`vw_mod_hours` `a`
        LEFT JOIN `vw_emp_org` `b` ON ((`a`.`emp_id` = `b`.`emp_id`)))
    GROUP BY `a`.`emp_id` , `a`.`comp_id` , `a`.`mon_name` , `a`.`yr_hours`
    HAVING (`a`.`yr_hours` > 0)