CREATE VIEW `v_shikkou_joukyou` AS select
 `t_master_yosangaku`.`年度` AS `年度`
,`t_master_yosangaku`.`予算CD` AS `予算CD`
,`t_master_yosangaku`.`当初予算` AS `当初予算`
,`t_master_yosangaku`.`補正増` AS `補正増`
,`t_master_yosangaku`.`補正減` AS `補正減`
,`t_master_yosangaku`.`流用増` AS `流用増`
,`t_master_yosangaku`.`流用減` AS `流用減`
,`t_master_yosangaku`.`現計予算` AS `現計予算`
,`t_master_shikkou`.`調定増` AS `調定増`
,`t_master_shikkou`.`調定減` AS `調定減`
,`t_master_shikkou`.`支出負担行為増` AS `支出負担行為増`
,`t_master_shikkou`.`支出負担行為減` AS `支出負担行為減`
,`t_master_shikkou`.`支出命令増` AS `支出命令増`
,`t_master_shikkou`.`支出命令減` AS `支出命令減`
 from (`t_master_yosangaku` join `t_master_shikkou` on
(((`t_master_yosangaku`.`予算CD` = `t_master_shikkou`.`予算CD`)
 and (`t_master_yosangaku`.`年度` = `t_master_shikkou`.`年度`))))

