CREATE VIEW `v_engi_shitei_short` AS select
 `t_engi_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`
,`t_engi_shitei`.`市町村登録番号` AS `市町村登録番号`
,`t_engi_shitei`.`下免許` AS `下免許`
,`t_engi_kojin`.`氏名` AS `氏名`
,`t_engi_kojin`.`ふりがな` AS `ふりがな`
,`t_engi_kojin`.`合格年度` AS `合格年度`
,`t_engi_kojin`.`生年月日` AS `生年月日`
,`t_engi_kojin`.`交付` AS `交付`
,`t_engi_kojin`.`有効期限` AS `有効期限`
,`t_engi_kojin`.`郵便番号` AS `郵便番号`
,`t_engi_kojin`.`住所1` AS `住所1`
,`t_engi_kojin`.`住所2` AS `住所2`
,`t_engi_kojin`.`住所3` AS `住所3`
,`t_engi_kojin`.`住所4` AS `住所4`
,`t_engi_kojin`.`住所5` AS `住所5`
,`t_engi_kojin`.`備考1` AS `備考1`
,`t_engi_kojin`.`備考2` AS `備考2`
 from ((`t_engi_shitei` join `t_jigyousha_shitei` on `t_engi_shitei`.`指定ID` = `t_jigyousha_shitei`.`指定ID`)
 join  `t_engi_kojin` on `t_engi_shitei`.`下免許` = `t_engi_kojin`.`責任技術者証番号`)
