Subversion Repositories VORC

## View: v_volhours
#
# +------------+-------------+------+-----+---------+-------+
# | Field      | Type        | Null | Key | Default | Extra |
# +------------+-------------+------+-----+---------+-------+
# | year       | bigint(20)  | YES  |     | NULL    |       |
# | RCid       | varchar(45) | YES  |     | NULL    |       |
# | derby_name | varchar(45) | YES  |     | NULL    |       |
# | full_name  | varchar(45) | YES  |     | NULL    |       |
# | dept       | varchar(45) | YES  |     | NULL    |       |
# | hours      | double      | YES  |     | NULL    |       |
# +------------+-------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_volhours` AS select `v_all_hours`.`year` AS `year`,`v_all_hours`.`RCid` AS `RCid`,`v_all_hours`.`derby_name` AS `derby_name`,`official`.`real_name` AS `full_name`,`v_all_hours`.`dept` AS `dept`,sum(`v_all_hours`.`hours`) AS `hours` from (`v_all_hours` left join `official` on((`v_all_hours`.`RCid` = `official`.`RCid`))) group by `v_all_hours`.`year`,`v_all_hours`.`RCid`,`v_all_hours`.`dept`