CREATE VIEW `v_engi_shitei_long2` AS select
 `v_engi_shitei_short`.`指定ID` AS `指定ID`
,`v_engi_shitei_short`.`市町村登録番号` AS `市町村登録番号`
,`v_engi_shitei_short`.`下免許` AS `下免許`
,`v_engi_shitei_short`.`市町村CD` AS `市町村CD`
,`v_engi_shitei_short`.`指定番号` AS `指定番号`
,`v_engi_shitei_short`.`指定日` AS `指定日`
,`v_engi_shitei_short`.`法人CD` AS `法人CD`
,`v_engi_shitei_short`.`事業所CD` AS `事業所CD`
,`v_engi_shitei_short`.`氏名` AS `氏名`
,`v_engi_shitei_short`.`ふりがな` AS `ふりがな`
,`v_engi_shitei_short`.`合格年度` AS `合格年度`
,`v_engi_shitei_short`.`生年月日` AS `生年月日`
,`v_engi_shitei_short`.`交付` AS `交付`
,`v_engi_shitei_short`.`有効期限` AS `有効期限`
,`v_engi_shitei_short`.`郵便番号` AS `郵便番号`
,`v_engi_shitei_short`.`住所1` AS `住所1`
,`v_engi_shitei_short`.`住所2` AS `住所2`
,`v_engi_shitei_short`.`住所3` AS `住所3`
,`v_engi_shitei_short`.`住所4` AS `住所4`
,`v_engi_shitei_short`.`住所5` AS `住所5`
,`v_engi_shitei_short`.`備考1` AS `備考1`
,`v_engi_shitei_short`.`備考2` AS `備考2`
,`v_hjcd_short`.`法人名称` AS `法人名称`
,`v_hjcd_short`.`法人カナ` AS `法人カナ`
,`v_hjcd_short`.`事業所名称` AS `事業所名称`
 from `v_engi_shitei_short` join  `v_hjcd_short`
 on (`v_engi_shitei_short`.`法人CD` = `v_hjcd_short`.`法人CD` and `v_engi_shitei_short`.`事業所CD` = `v_hjcd_short`.`事業所CD`)
