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

CREATE VIEW `vgijutsu2593` AS select `tgijutsusha2598`.`免状番号` AS `免状番号`,`tgijutsusha2200`.`主任技術者名` AS `主任技術者名`,`tgijutsusha2598`.`選任日` AS `選任日`,`tgijutsusha2598`.`解任日` AS `解任日`,`tgijutsusha2598`.`選任状態CD` AS `選任状態CD`,`tgijutsusha2200`.`交付年月日` AS `交付年月日`,`tgijutsusha2200`.`ふりがな` AS `ふりがな`,`tgijutsusha2200`.`生年月日` AS `生年月日`,`tgijutsusha2598`.`法人CD` AS `法人CD`,`tgijutsusha2598`.`事業所CD` AS `事業所CD`,`tcdhoujin1532`.`法人名称` AS `法人名称`,`tcdjigyousho1543`.`事業所名称` AS `事業所名称` from (((`tgijutsusha2200` join `tgijutsusha2598` on((`tgijutsusha2200`.`免状番号` = `tgijutsusha2598`.`免状番号`))) join `tcdjigyousho1543` on(((`tgijutsusha2598`.`事業所CD` = `tcdjigyousho1543`.`事業所CD`) and (`tgijutsusha2598`.`法人CD` = `tcdjigyousho1543`.`法人CD`)))) join `tcdhoujin1532` on((`tcdjigyousho1543`.`法人CD` = `tcdhoujin1532`.`法人CD`))) order by `tgijutsusha2598`.`免状番号`;

