CREATE VIEW `v_engi_jigyousha_shitei` AS select
 `t_jigyousha_shitei`.`指定ID` AS `指定ID`
,`t_jigyousha_shitei`.`市町村CD` AS `市町村CD`
,`t_jigyousha_shitei`.`指定番号` AS `指定番号`
,`t_jigyousha_shitei`.`指定日` AS `指定日`
,`t_jigyousha_shitei`.`法人CD` AS `法人CD`
,`t_jigyousha_shitei`.`事業所CD` AS `事業所CD`
,`v_hjcd_short`.`法人名称` AS `法人名称`
,`v_hjcd_short`.`法人カナ` AS `法人カナ`
,`v_hjcd_short`.`事業所名称` AS `事業所名称`
,`tcd_city`.`市町村名` AS `市町村名`
,`t_engi_shitei`.`市町村登録番号` AS `市町村登録番号`
,`t_engi_shitei`.`下免許` AS `下免許`
 from ((((`t_jigyousha_shitei` join `v_hjcd_short`
 on(`t_jigyousha_shitei`.`法人CD` = `v_hjcd_short`.`法人CD`
 and `t_jigyousha_shitei`.`事業所CD` = `v_hjcd_short`.`事業所CD`))
 join `tcd_houjin`
 on `t_jigyousha_shitei`.`法人CD` = `tcd_houjin`.`法人CD`)
 join `tcd_city`
 on `tcd_city`.`市町村CD` = `t_jigyousha_shitei`.`市町村CD`)
 join `t_engi_shitei`
 on `t_engi_shitei`.`指定ID` = `t_jigyousha_shitei`.`指定ID`)
