create view `narajwwa_shinsei2`.`v_hjlist_city_long` as select
 `narajwwa_shinsei2`.`tcd_city`.`市町村CD` AS `市町村CD`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`法人CD` AS `法人CD`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`事業所CD` AS `事業所CD`
,`narajwwa_shinsei2`.`tcd_city`.`市町村名` AS `市町村名`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`指定番号` AS `指定番号`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`有効期限` AS `有効期限`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`指定状態CD` AS `指定状態CD`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`指定日` AS `指定日`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`取消日` AS `取消日`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`更新日` AS `更新日`
,`narajwwa_shinsei2`.`t_jigyousha_city`.`指定備考` AS `指定備考`
,`narajwwa_shinsei2`.`tcd_jigyousho`.`事業所名称` AS `事業所名称`
,`narajwwa_shinsei2`.`tcd_jigyousho`.`事業所郵便` AS `事業所郵便`
,`narajwwa_shinsei2`.`tcd_jigyousho`.`事業所住所` AS `事業所住所`
,`narajwwa_shinsei2`.`tcd_jigyousho`.`事業所電話` AS `事業所電話`
,`narajwwa_shinsei2`.`tcd_jigyousho`.`事業所備考` AS `事業所備考`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人名称` AS `法人名称`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人カナ` AS `法人カナ`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人郵便` AS `法人郵便`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人住所` AS `法人住所`
,`narajwwa_shinsei2`.`tcd_houjin`.`代表者肩書` AS `代表者肩書`
,`narajwwa_shinsei2`.`tcd_houjin`.`代表者氏名` AS `代表者氏名`
,`narajwwa_shinsei2`.`tcd_houjin`.`代表者カナ` AS `代表者カナ`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人本拠` AS `法人本拠`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人電話` AS `法人電話`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人FAX` AS `法人FAX`
,`narajwwa_shinsei2`.`tcd_houjin`.`連絡先メール` AS `連絡先メール`
,`narajwwa_shinsei2`.`tcd_houjin`.`連絡先電話` AS `連絡先電話`
,`narajwwa_shinsei2`.`tcd_houjin`.`連絡先携帯` AS `連絡先携帯`
,`narajwwa_shinsei2`.`tcd_houjin`.`法人備考` AS `法人備考`
,`narajwwa_shinsei2`.`tcd_houjin`.`廃業CD` AS `廃業CD`
 from (((`narajwwa_shinsei2`.`t_jigyousha_city` join `narajwwa_shinsei2`.`tcd_city`
 on((`narajwwa_shinsei2`.`t_jigyousha_city`.`市町村CD` = `narajwwa_shinsei2`.`tcd_city`.`市町村CD`)))
 join `narajwwa_shinsei2`.`tcd_jigyousho`
 on(((`narajwwa_shinsei2`.`t_jigyousha_city`.`事業所CD` = `narajwwa_shinsei2`.`tcd_jigyousho`.`事業所CD`)
 and (`narajwwa_shinsei2`.`t_jigyousha_city`.`法人CD` = `narajwwa_shinsei2`.`tcd_jigyousho`.`法人CD`))))
 join `narajwwa_shinsei2`.`tcd_houjin`
 on((`narajwwa_shinsei2`.`tcd_jigyousho`.`法人CD` = `narajwwa_shinsei2`.`tcd_houjin`.`法人CD`)))
 order by `narajwwa_shinsei2`.`tcd_city`.`市町村CD`,`narajwwa_shinsei2`.`t_jigyousha_city`.`指定番号`
