CREATE VIEW `v_keizoku` AS select
 `t_keizoku3`.`ID` AS `ID`
,`t_keizoku3`.`事業ID` AS `事業ID1`
,`t_keizoku3`.`年度` AS `年度`
,`t_keizoku3`.`年割額` AS `年割額`
,`t_keizoku3`.`企業債` AS `企業債`
,`t_keizoku3`.`留保資金等` AS `留保資金等`
,`t_keizoku3`.`前前年度末まで` AS `前前年度末まで`
,`t_keizoku3`.`前年度末まで` AS `前年度末まで`
,`t_keizoku3`.`当該年度` AS `当該年度`
,`t_keizoku3`.`当該年度末` AS `当該年度末`
,`t_keizoku3`.`翌年度以降` AS `翌年度以降`
,`t_keizoku3`.`進捗率` AS `進捗率`
,`t_keizoku3`.`備考` AS `備考`
,`t_keizoku2`.`事業ID` AS `事業ID2`
,`t_keizoku2`.`区分` AS `区分`
,`t_keizoku2`.`款` AS `款`
,`t_keizoku2`.`項` AS `項`
,`t_keizoku2`.`事業名` AS `事業名`
 from `t_keizoku3` join `t_keizoku2` on `t_keizoku3`.`事業ID` = `t_keizoku2`.`事業ID`

