--
-- ビュー用の構造 `vshiteigijutsu11835`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`narajwwa`@`%` SQL SECURITY DEFINER VIEW `vshiteigijutsu11835` AS select `tshiteijigyousha4503`.`市町村CD` AS `市町村CD`,`tcdshichouson`.`市町村名` AS `市町村名`,`tshiteijigyousha4503`.`指定番号` AS `指定番号`,`tshiteijigyousha4503`.`法人CD` AS `法人CD`,`tshiteijigyousha4503`.`事業所CD` AS `事業所CD`,`tgijutsusha2598`.`免状番号` AS `免状番号`,`tgijutsusha2598`.`選任日` AS `選任日`,`tgijutsusha2598`.`解任日` AS `解任日`,`tgijutsusha2598`.`選任状態CD` AS `選任状態CD`,`tgijutsusha2200`.`主任技術者名` AS `主任技術者名`,`tgijutsusha2200`.`交付年月日` AS `交付年月日`,`tgijutsusha2200`.`ふりがな` AS `ふりがな`,`tgijutsusha2200`.`生年月日` AS `生年月日` from (((`tgijutsusha2598` join `tshiteijigyousha4503` on(((`tgijutsusha2598`.`法人CD` = `tshiteijigyousha4503`.`法人CD`) and (`tgijutsusha2598`.`事業所CD` = `tshiteijigyousha4503`.`事業所CD`)))) join `tgijutsusha2200` on((`tgijutsusha2598`.`免状番号` = `tgijutsusha2200`.`免状番号`))) join `tcdshichouson` on((`tshiteijigyousha4503`.`市町村CD` = `tcdshichouson`.`市町村CD`))) order by `tshiteijigyousha4503`.`市町村CD`,`tshiteijigyousha4503`.`指定番号`;

