Subversion Repositories VORC

## View: v_volhours_report
#
# +------------+-------------+------+-----+---------+-------+
# | Field      | Type        | Null | Key | Default | Extra |
# +------------+-------------+------+-----+---------+-------+
# | year       | bigint(20)  | YES  |     | NULL    |       |
# | RCid       | int(11)     | NO   |     | 0       |       |
# | derby_name | varchar(45) | NO   |     | NULL    |       |
# | real_name  | varchar(45) | NO   |     | NULL    |       |
# | email      | varchar(45) | NO   |     | NULL    |       |
# | totalhours | double      | YES  |     | NULL    |       |
# +------------+-------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_volhours_report` AS select `v_volhours`.`year` AS `year`,`official`.`RCid` AS `RCid`,`official`.`derby_name` AS `derby_name`,`official`.`real_name` AS `real_name`,`official`.`email` AS `email`,sum(`v_volhours`.`hours`) AS `totalhours` from (`official` join `v_volhours`) where (`official`.`RCid` = `v_volhours`.`RCid`) group by `v_volhours`.`year`,`v_volhours`.`RCid`