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

CREATE VIEW `vshinseisho1530` AS select `tshinsei2031`.`申請ID` AS `申請ID`,`tshinsei2031`.`法人個人` AS `法人個人`,`tshinsei2031`.`申請日` AS `申請日`,`tshinsei2031`.`市町村数` AS `市町村数`,`tshinsei2031`.`法人CD` AS `法人CD`,`tshinsei2031`.`事業所CD` AS `事業所CD`,`tshinsei2031`.`受付日` AS `受付日`,`tshinsei2031`.`審査状態CD` AS `審査状態CD`,`tshinsei2031`.`申請備考` AS `申請備考`,`thyoushi1530`.`奈良市` AS `奈良市`,`thyoushi1530`.`大和高田市` AS `大和高田市`,`thyoushi1530`.`大和郡山市` AS `大和郡山市`,`thyoushi1530`.`天理市` AS `天理市`,`thyoushi1530`.`橿原市` AS `橿原市`,`thyoushi1530`.`桜井市` AS `桜井市`,`thyoushi1530`.`五條市` AS `五條市`,`thyoushi1530`.`御所市` AS `御所市`,`thyoushi1530`.`生駒市` AS `生駒市`,`thyoushi1530`.`香芝市` AS `香芝市`,`thyoushi1530`.`葛城市` AS `葛城市`,`thyoushi1530`.`宇陀市` AS `宇陀市`,`thyoushi1530`.`平群町` AS `平群町`,`thyoushi1530`.`三郷町` AS `三郷町`,`thyoushi1530`.`斑鳩町` AS `斑鳩町`,`thyoushi1530`.`安堵町` AS `安堵町`,`thyoushi1530`.`川西町` AS `川西町`,`thyoushi1530`.`三宅町` AS `三宅町`,`thyoushi1530`.`田原本町` AS `田原本町`,`thyoushi1530`.`高取町` AS `高取町`,`thyoushi1530`.`明日香村` AS `明日香村`,`thyoushi1530`.`上牧町` AS `上牧町`,`thyoushi1530`.`王寺町` AS `王寺町`,`thyoushi1530`.`広陵町` AS `広陵町`,`thyoushi1530`.`河合町` AS `河合町`,`thyoushi1530`.`吉野町` AS `吉野町`,`thyoushi1530`.`大淀町` AS `大淀町`,`thyoushi1530`.`下市町` AS `下市町` from (`thyoushi1530` join `tshinsei2031` on((`thyoushi1530`.`申請ID` = `tshinsei2031`.`申請ID`)));

