| 208 |
- |
1 |
## View: v_volhours_report
|
|
|
2 |
#
|
|
|
3 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
6 |
# | year | bigint(20) | YES | | NULL | |
|
|
|
7 |
# | RCid | int(11) | NO | | 0 | |
|
|
|
8 |
# | derby_name | varchar(45) | NO | | NULL | |
|
|
|
9 |
# | real_name | varchar(45) | NO | | NULL | |
|
|
|
10 |
# | email | varchar(45) | NO | | NULL | |
|
|
|
11 |
# | totalhours | double | YES | | NULL | |
|
|
|
12 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
13 |
|
|
|
14 |
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`
|