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

CREATE VIEW `vshiteijigyousha4500` AS select `tcdshichouson`.`市町村CD` AS `市町村CD`,`tshiteijigyousha4503`.`法人CD` AS `法人CD`,`tshiteijigyousha4503`.`事業所CD` AS `事業所CD`,`tcdshichouson`.`市町村名` AS `市町村名`,`tshiteijigyousha4503`.`指定番号` AS `指定番号`,`tshiteijigyousha4503`.`分類` AS `分類`,`tshiteijigyousha4503`.`指定状態CD` AS `指定状態CD`,`tshiteijigyousha4503`.`指定日` AS `指定日`,`tshiteijigyousha4503`.`取消日` AS `取消日`,`tshiteijigyousha4503`.`取消事由` AS `取消事由`,`tshiteijigyousha4503`.`指定備考` AS `指定備考`,`tcdjigyousho1543`.`事業所名称` AS `事業所名称`,`tcdjigyousho1543`.`事業所郵便` AS `事業所郵便`,`tcdjigyousho1543`.`事業所住所` AS `事業所住所`,`tcdjigyousho1543`.`事業所電話` AS `事業所電話`,`tcdjigyousho1543`.`事業所備考` AS `事業所備考`,`tcdhoujin1532`.`法人名称` AS `法人名称`,`tcdhoujin1532`.`法人郵便` AS `法人郵便`,`tcdhoujin1532`.`法人住所` AS `法人住所`,`tcdhoujin1532`.`代表者肩書` AS `代表者肩書`,`tcdhoujin1532`.`代表者氏名` AS `代表者氏名`,`tcdhoujin1532`.`代表者カナ` AS `代表者カナ`,`tcdhoujin1532`.`法人本拠` AS `法人本拠`,`tcdhoujin1532`.`法人電話` AS `法人電話`,`tcdhoujin1532`.`法人FAX` AS `法人FAX`,`tcdhoujin1532`.`連絡先メール` AS `連絡先メール`,`tcdhoujin1532`.`連絡先電話` AS `連絡先電話`,`tcdhoujin1532`.`連絡先携帯` AS `連絡先携帯`,`tcdhoujin1532`.`法人備考` AS `法人備考`,`tcdhoujin1532`.`廃業CD` AS `廃業CD` from (((`tshiteijigyousha4503` join `tcdshichouson` on((`tshiteijigyousha4503`.`市町村CD` = `tcdshichouson`.`市町村CD`))) join `tcdjigyousho1543` on(((`tshiteijigyousha4503`.`事業所CD` = `tcdjigyousho1543`.`事業所CD`) and (`tshiteijigyousha4503`.`法人CD` = `tcdjigyousho1543`.`法人CD`)))) join `tcdhoujin1532` on((`tcdjigyousho1543`.`法人CD` = `tcdhoujin1532`.`法人CD`))) order by `tcdshichouson`.`市町村CD`,`tshiteijigyousha4503`.`指定番号`;

