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