CREATE ALGORITHM=UNDEFINED DEFINER=`narajwwa`@`%` SQL SECURITY DEFINER VIEW `v_engi_city` AS select `t_engi_city`.`ID` AS `ID`,`t_engi_city`.`登録市町村CD` AS `登録市町村CD`,`tcd_city`.`市町村名` AS `市町村名`,`t_engi_city`.`法人CD` AS `法人CD`,`v_hjcd`.`法人名称` AS `法人名称`,`t_engi_city`.`事業所CD` AS `事業所CD`,`v_hjcd`.`事業所名称` AS `事業所名称`,`t_engi_city`.`免状番号` AS `免状番号`,`t_engi_city`.`選任日` AS `選任日`,`t_engi_city`.`解任日` AS `解任日`,`t_engi_city`.`選任状態CD` AS `選任状態CD`,`t_engi_kojin`.`主任技術者名` AS `主任技術者名`,`t_engi_kojin`.`交付年月日` AS `交付年月日`,`t_engi_kojin`.`ふりがな` AS `ふりがな`,`t_engi_kojin`.`生年月日` AS `生年月日`
 from (((`t_engi_city` join `t_engi_kojin` on((`t_engi_city`.`免状番号` = `t_engi_kojin`.`免状番号`))) join `tcd_city` on((`t_engi_city`.`登録市町村CD` = `tcd_city`.`市町村CD`))) join `v_hjcd` on(((`t_engi_city`.`法人CD` = `v_hjcd`.`法人CD`) and (`t_engi_city`.`事業所CD` = `v_hjcd`.`事業所CD`)))) order by `t_engi_city`.`登録市町村CD`