CREATE VIEW `v_engi_jigyousha` AS select
 `v_jigyousha_shitei`.`指定ID` AS `指定ID`
,`v_jigyousha_shitei`.`市町村CD` AS `市町村CD`
,`v_jigyousha_shitei`.`指定番号` AS `指定番号`
,`v_jigyousha_shitei`.`指定日` AS `指定日`
,`v_jigyousha_shitei`.`法人CD` AS `法人CD`
,`v_jigyousha_shitei`.`事業所CD` AS `事業所CD`
,`v_jigyousha_shitei`.`法人名称` AS `法人名称`
,`v_jigyousha_shitei`.`事業所名称` AS `事業所名称`
,`v_jigyousha_shitei`.`市町村名` AS `市町村名`
,`t_engi_shitei`.`市町村登録番号` AS `市町村登録番号`
,`t_engi_shitei`.`下免許` AS `下免許`
 from `v_jigyousha_shitei` join `t_engi_shitei` on `v_jigyousha_shitei`.`指定ID` = `t_engi_shitei`.`指定ID`
 order by `v_jigyousha_shitei`.`市町村CD`
