CREATE VIEW `v_ikkenshori_bangou` AS select
`t_denpyou_boki`.`簿記伝票ID` AS `簿記伝票ID`
,`t_denpyou_boki`.`伺ID` AS `伺ID`
,`t_denpyou_yosan`.`予算伝票ID` AS `予算伝票ID`
,`t_denpyou_yosan`.`執行CD` AS `執行CD`
,`t_denpyou_yosan`.`一件処理番号` AS `一件処理番号`
,`t_denpyou_boki`.`所属CD` AS `所属CD`
,`t_denpyou_boki`.`摘要名称` AS `摘要名称`
,`t_denpyou_boki`.`借方CD` AS `借方CD`
,`t_denpyou_boki`.`借方金額` AS `借方金額`
,`t_denpyou_boki`.`貸方CD` AS `貸方CD`
,`t_denpyou_boki`.`貸方金額` AS `貸方金額`
,`t_denpyou_boki`.`発行日` AS `発行日`
 from `t_denpyou_boki` join `t_denpyou_yosan`
 on `t_denpyou_boki`.`伺ID` = `t_denpyou_yosan`.`伺ID`
