CREATE VIEW `vuketsuke2018` AS select `tshinsei2031`.`申請ID` AS `申請ID`,`tshinsei2031`.`申請ID2` AS `申請ID2`,`tshinsei2031`.`来局郵送` AS `来局郵送`,`tshinsei2031`.`受付日` AS `受付日`,`tshinsei2031`.`市町村数` AS `市町村数`,`tcdhoujin1532`.`法人CD` AS `法人CD`,`tcdhoujin1532`.`法人名称` AS `法人名称`,`tcdjigyousho1543`.`事業所CD` AS `事業所CD`,`tcdjigyousho1543`.`事業所名称` AS `事業所名称`,`tshinsei2031`.`法人個人` AS `法人個人`,`tshinsei2031`.`担当者` AS `担当者`,`tcdhoujin1532`.`連絡先電話` AS `連絡先電話`,`tcdjigyousho1543`.`事業所電話` AS `事業所電話`,`tshinsei2031`.`申請備考` AS `申請備考` from ((`tshinsei2031` join `tcdhoujin1532` on((`tshinsei2031`.`法人CD` = `tcdhoujin1532`.`法人CD`))) join `tcdjigyousho1543` on(((`tshinsei2031`.`事業所CD` = `tcdjigyousho1543`.`事業所CD`) and (`tshinsei2031`.`法人CD` = `tcdjigyousho1543`.`法人CD`))));
