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

CREATE VIEW `vshiteijigyousha4503` AS select `tshiteijigyousha4503`.`法人CD` AS `法人CD`,`tshiteijigyousha4503`.`事業所CD` AS `事業所CD`,`tshiteijigyousha4503`.`市町村CD` AS `市町村CD`,`tshiteijigyousha4503`.`指定番号` AS `指定番号`,`tshiteijigyousha4503`.`分類` AS `分類`,`tshiteijigyousha4503`.`指定状態CD` AS `指定状態CD`,`tshiteijigyousha4503`.`指定日` AS `指定日`,`tshiteijigyousha4503`.`取消日` AS `取消日`,`tshiteijigyousha4503`.`取消事由` AS `取消事由`,`tshiteijigyousha4503`.`指定備考` AS `指定備考`,`tcdshichouson`.`市町村名` AS `市町村名` from (`tshiteijigyousha4503` join `tcdshichouson` on((`tshiteijigyousha4503`.`市町村CD` = `tcdshichouson`.`市町村CD`))) order by `tshiteijigyousha4503`.`市町村CD`,`tshiteijigyousha4503`.`指定番号`;

